Forum Discussion
how do i duplicate rows based on a cells value
im trying to get data from one table and add it multiple times to another table based on the max qty product max qty order product qty product 1 6 12 product 1 6 product...
The desired result is not clear from the example. To pull rows multiple times you could use CHOOSEROWS/SEQUENCE or INDEX/SEQUENCE.