aravindhan_3
10-17-2008, 05:45 AM
Hi,
I have the data in sheet 1 like below. the numbers which are highlighter, like 821 & 3675, 180 & 5718 etc are the headers. 821 & 3675 are the header and some data is filled under that , then there will be an empty Row. again there is another header and some data below that.and an empty row again, I have data like this for about 5000 rows...
Col A------------ ColB
821 ------------- 3675
9885874 ------------- 44
Empty Row
180 ------------- 5718
2721072 ------------- 2
Empty Row
821 ------------- 3675
4224528 ------------- 28
4476583 ------------- 25
4510178 ------------- 29
5096627 ------------- 28
5124866 ------------- 50
5125462 ------------- 30
Empty Row
821 ------------- 3675
5096627 ------------- 28
5124866 ------------- 50
Empty Row
etc
I want to cut the the header and paste in Column C & D next to the data.
The result should look like this.
Col A--------------- ColB -Col C ----------Col D
9885874 ------------- 44 821 ------------- 3675
Empty Row
2721072 ------------- 2 180 ------------- 5718
Empty Row
4224528 ------------- 28 821 ------------- 3675
4476583 ------------- 25 821 ------------- 3675
4510178 ------------- 29 821 ------------- 3675
5096627 ------------- 28 821 ------------- 3675
5124866 ------------- 50 821 ------------- 3675
5125462 ------------- 30 821 ------------- 3675
Empty Row
5096627 ------------- 28 821 ------------- 3675
5124866 ------------- 50 821 ------------- 3675
Empty Row
Etc..
Appreciate your help.
I have the data in sheet 1 like below. the numbers which are highlighter, like 821 & 3675, 180 & 5718 etc are the headers. 821 & 3675 are the header and some data is filled under that , then there will be an empty Row. again there is another header and some data below that.and an empty row again, I have data like this for about 5000 rows...
Col A------------ ColB
821 ------------- 3675
9885874 ------------- 44
Empty Row
180 ------------- 5718
2721072 ------------- 2
Empty Row
821 ------------- 3675
4224528 ------------- 28
4476583 ------------- 25
4510178 ------------- 29
5096627 ------------- 28
5124866 ------------- 50
5125462 ------------- 30
Empty Row
821 ------------- 3675
5096627 ------------- 28
5124866 ------------- 50
Empty Row
etc
I want to cut the the header and paste in Column C & D next to the data.
The result should look like this.
Col A--------------- ColB -Col C ----------Col D
9885874 ------------- 44 821 ------------- 3675
Empty Row
2721072 ------------- 2 180 ------------- 5718
Empty Row
4224528 ------------- 28 821 ------------- 3675
4476583 ------------- 25 821 ------------- 3675
4510178 ------------- 29 821 ------------- 3675
5096627 ------------- 28 821 ------------- 3675
5124866 ------------- 50 821 ------------- 3675
5125462 ------------- 30 821 ------------- 3675
Empty Row
5096627 ------------- 28 821 ------------- 3675
5124866 ------------- 50 821 ------------- 3675
Empty Row
Etc..
Appreciate your help.