Single Column to Rows

edit

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.

Menu/Data/Text to columns ?