| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I save an excel file as a file with undelimited text | Excel Discussion (Misc queries) | |||
| How do you save an excel file to be read as IBM-type text file ? | Excel Worksheet Functions | |||
| How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) | |||
| How can I save a file as a comma-delimited text file in Excel? | Excel Discussion (Misc queries) | |||
| Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) | |||
Threaded Mode
