Hi,
How do identify a header versus data row as a assume the number of
data rows per header is different?



"Pich" wrote:


Hi!

I have an Excel file in which all my data is in 1 column but on a lot
of rows. I want to restructure it to more columns instead. Like this
example:


NOW I HAVE:
Field 1A Header1
Field 2A Data1
Field 3A Header2
Field 4A Data2
Field 5A Header3
Field 6A Data3

I WANT IT LIKE THIS:
Field 1A Header1
Field 2A Data1
Field 1B Header2
Field 2B Data2
Field 1C Header3
Field 2C Data3


Of course I have a lot of more data under each header, but it is number
of data rows are ambigous.

Is that possible by using some sort of script or macro?

Regards

Pich


--
Pich
------------------------------------------------------------------------
Pich's Profile: http://www.excelforum.com/member.php...o&userid=29007
View this thread: http://www.excelforum.com/showthread...hreadid=487353