I have data in multiple columns that repeats except for one date reference. The X0 column starts with a date and the date updates with the next data reference. I need to move the All data like the reference number in column A down to the next row until all have been moved. Column A is the place holder for the data. The data may repeat many more times than the example. In the example it only repeats 4 times. There are also many more columns of data, but in the example there are only 4.
The macro should run until there is no more data to move. The result should look like the lower example. I'm not sure how I can do this. I can modify a macro created with this example but have no clue as to how to begin to write it.
Any help would be welcome. Thanks in advance.
Data comes in like this
A B C D E F G H I J K L M N O P
NUMA NUMB X0 X0H
101064 670 3/1/2014 0.50 101064 670 4/1/2014 0.50 101064 670 5/1/2014 0.50 101064 670 6/1/2014 0.50
102065 671 3/1/2014 0.50 102065 671 4/1/2014 0.50 102065 671 5/1/2014 0.50 102065 671 6/1/2014 0.50
103067 673 3/1/2014 0.50 103067 673 4/1/2014 0.50 103067 673 5/1/2014 0.50 103067 673 6/1/2014 0.50
Would like to have it look like this
A B C D
NUMA NUMB X0 X0H
101064 670 3/1/2014 0.50
101064 670 4/1/2014 0.50
101064 670 5/1/2014 0.50
101064 670 6/1/2014 0.50
102065 671 3/1/2014 0.50
102065 671 4/1/2014 0.50
102065 671 5/1/2014 0.50
102065 671 6/1/2014 0.50
103067 673 3/1/2014 0.50
103067 673 4/1/2014 0.50
103067 673 5/1/2014 0.50
103067 673 6/1/2014 0.50
The macro should run until there is no more data to move. The result should look like the lower example. I'm not sure how I can do this. I can modify a macro created with this example but have no clue as to how to begin to write it.
Any help would be welcome. Thanks in advance.
Data comes in like this
A B C D E F G H I J K L M N O P
NUMA NUMB X0 X0H
101064 670 3/1/2014 0.50 101064 670 4/1/2014 0.50 101064 670 5/1/2014 0.50 101064 670 6/1/2014 0.50
102065 671 3/1/2014 0.50 102065 671 4/1/2014 0.50 102065 671 5/1/2014 0.50 102065 671 6/1/2014 0.50
103067 673 3/1/2014 0.50 103067 673 4/1/2014 0.50 103067 673 5/1/2014 0.50 103067 673 6/1/2014 0.50
Would like to have it look like this
A B C D
NUMA NUMB X0 X0H
101064 670 3/1/2014 0.50
101064 670 4/1/2014 0.50
101064 670 5/1/2014 0.50
101064 670 6/1/2014 0.50
102065 671 3/1/2014 0.50
102065 671 4/1/2014 0.50
102065 671 5/1/2014 0.50
102065 671 6/1/2014 0.50
103067 673 3/1/2014 0.50
103067 673 4/1/2014 0.50
103067 673 5/1/2014 0.50
103067 673 6/1/2014 0.50