Single Column to Rows

I have a text file with a single line of information which needs to be ultimately parsed into a DB.

File looks like this:

CustomerID1
CustomerName
Street
CityST

CustomerID2
CustomerName2
Street2
CityST2

and so on for 2000 lines.

I need to know if there is way to manipulate this in CALC to create:

CustomerID1 CustomerName1 Street1 CityST1
CustomerID2 CustomerName2 Street2 CityST2

with each former row being a separate cell.

Transpose swings the whole column into one row, I need one row per customerID.
Thanks

Menu/Data/Text to columns ?

Hi

I’m not sure I understand. If your file is as you describe, and each line of the file must be placed in a single cell, there is nothing special to do. At the opening in Calc dialog opens:

Simply validate with OK.

On the other hand you write:

I need to know if there is way to manipulate this in CALC to create:

CustomerID1 CustomerName1 Street1 CityST1 CustomerID2 CustomerName2 Street2 CityST2

I guess it’s a layout error due to the syntax of the forum. If you really wanted all records on a single line that would not be possible because there are only 1024 columns.

Ended up manually using “Copy”, then “Paste Special” with ‘Transpose’ selected.

Not an elegant solution, but quick enough.