Match columns

[light]

A B C
1 x 1
1 x 2
1 x 3
1 x 4
1 x 5
1 x 6
2 x 7
2 x 8
2 x 9
2 x 10
2 x
2 x
3 x
3 x
3 x
ETC....to 10

Actually column A goes down about 1000 rows. Number of times a number is reapeated in column A varies. Numbers in column C varies and determines the range of numbers in A.I need a macro that will match column C to all the numbers in Column A. Cannot use a fill proceedure as this is part of a larger program. So result should look like.

B]A B C[/B]
1 x 1
1 x 1
1 x 1
1 x 1
1 x 1
1 x 1
2 x 2
2 x 2
2 x 2
2 x 2
2 x 2
2 x 2
3 x 3
3 x 3
3 x 3.....Etc

[jindon]

try

Please Login or Register  to view this content.