View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Illuminator Illuminator is offline
external usenet poster
 
Posts: 2
Default 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!