Ask Your Question
0

Single Column to Rows

asked 2015-04-08 23:32:52 +0200

RebTech gravatar image

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

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
0

answered 2015-04-09 16:53:47 +0200

RebTech gravatar image

Ended up manually using "Copy", then "Paste Special" with 'Transpose' selected.

Not an elegant solution, but quick enough.

edit flag offensive delete link more
0

answered 2015-04-09 08:47:08 +0200

pierre-yves samyn gravatar image

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:

screenshot

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.

edit flag offensive delete link more
0

answered 2015-04-09 00:52:31 +0200

m.a.riosv gravatar image

updated 2015-04-09 00:53:08 +0200

Menu/Data/Text to columns ?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-04-08 23:32:52 +0200

Seen: 69 times

Last updated: Apr 09 '15