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!
|