Solved: Cut Header from a set of data and paste the same next to the Data in C& D Col

[aravindhan_3]

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.

[aravindhan_3]

Hi,

I got an answer for this in the below url
http://www.excelforum.com/excel-prog...and-d-col.html

Thanks...