Text file to excel
 

Hi!

I have a text file with the following format:
header 1, value 1, value 2, value 3, value 4, header2, value 5, value 6,
value 7, value 8, header 3, value 9, value 10, value 11, value 12.

I want to import this file into excel and have the following structure in
excel:
header 1 header 2 header 3
value 1 value 5 value 9
value 2 value 6 value 10
value 3 value 7 value 11
value 4 value 8 value 12


How can I achieve this?

Thanks!

Text file to excel
 

Hi
If you import it and do DataText to ColumnsDelimitedselect Comma as
delimiterfinish it will come into the sheet in cells A1:M1
In cell A2 enter
=INDEX($1:$1,ROW()+4*(COLUMN()-1))
copy down through A3:A5
Copy A2:A5 across through B2:C2
Copy A2:C5Paste Special Values
Change B1 and C1 to Header 2 and Header 3

--
Regards
Roger Govier

"Illuminator" wrote in message
...
Hi!

I have a text file with the following format:
header 1, value 1, value 2, value 3, value 4, header2, value 5, value 6,
value 7, value 8, header 3, value 9, value 10, value 11, value 12.

I want to import this file into excel and have the following structure in
excel:
header 1 header 2 header 3
value 1 value 5 value 9
value 2 value 6 value 10
value 3 value 7 value 11
value 4 value 8 value 12


How can I achieve this?

Thanks!