Hello,
I have a txt file that has multiple rows of data that i want to condense into one row with multiple columns in a XLS file. For Example


TXT file:
-------------------------------------------------------------
field1: record1-field1number
field2: record1-field2text
field3: record1-field3text
field4:
field 4 text
takes up 2 lines

field1: record2-field1number
field2: record2-field2text
field3: record2-field3text
field4:
field 4 text
takes up 2 lines


DESIRED XLS FILE ( | denotes next cell)
-------------------------------------------------------------

record1-field1number | record1-field2text | record1-field3text
record2-field1number | record2-field2text | record2-field3text