Insert varying number of rows based on count

Closed
dors - May 17, 2010 at 11:28 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 18, 2010 at 02:20 AM
I have 3 column. Column 3 indicate how many rows to insert. then copy cell values of col 1 and col 2

data format:

col1 col2 col3
row1 r1c1 r1c2 4 ---> 4 rows to insert
row2 r2c1 r2c2 2 ---> 2 rows to insert
row3 r3c1 r3c2 0 ---> no row to insert
row4 r3c1 r3c2 1 ---> 1 row to insert



new outputformat :

col1 col2 col3
row1 r1c1 r1c2 4
row2 r1c1 r1c2 4
row3 r1c1 r1c2 4
row4 r1c1 r1c2 4

row5 r2c1 r2c2 2
row6 r2c1 r2c2 2

row7 r3c1 r3c2 0

row4 r3c1 r3c2 1

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
May 18, 2010 at 02:20 AM
0