Insert rows based on count of rows

Closed
dors - May 14, 2010 at 04:01 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 14, 2010 at 04:34 AM
i want a macro to insert empty rows bsed on count then copy each values from column C to E to the inserted rows (rows after the first the value)

to illustrate, transform the original data to target ouput

original format:

col/row A B C D E
1 count v1 v2 v3 v4
2 4 ab1 ab2 ab3 ab4
3 3 bc1 bc2 bc3
4 2 cd1 cd2
5 1 ef


target output:

col/row A B C D E
1 count v1 v2 v3 v4
2 4 ab1
3 ab2
4 ab3
5 ab4
6 3 bc1
7 bc2
8 bc3
9 2 cd1
10 cd2
11 1 ef






1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
May 14, 2010 at 04:34 AM
0