Insert multiple columns then copy data

Closed
dors - 14 May 2010 à 05:05
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 14 May 2010 à 06:47
I want a macro to insert varying number of columns then copy the corresponding data

original data:
ColumnA ColumnB ColumnC
Count
Row1 "5" x1 y1
Row2 "6" x2 y2
Row3 "3" x3 y3
Row4 "0" x4 y5
Row5 "1" x5 y6
.... ..... .... ....

Target output:

ColumnA ColumnB ColumnC
Count
Row1 "5" x1 y1
Row2 "5" x1 y1
Row3 "5" x1 y1
Row4 "5" x1 y1
Row5 "5" x1 y1

Row6 "6" x2 y2
Row7 "6" x2 y2
Row8 "6" x2 y2
Row9 "6" x2 y2
Row10 "6" x2 y2
Row11 "6" x2 y2

Row12 "3" x3 y3
Row13 "3" x3 y3
Row14 "3" x3 y3

Row15 "0" x4 y5

Row16 "1" x5
.... ..... .... ....



Thanks in advance.
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
14 May 2010 à 06:47