Single Column to Rows

[RebTech]

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

[mariosv]

Menu/Data/Text to columns ?

[PYS]

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.

[RebTech]

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

Not an elegant solution, but quick enough.