질문하기

RebTech's profile - activity

2017-12-19 06:54:55 +0200 받은 배지  정리의 달인
2015-04-09 21:31:43 +0200 받은 배지  주목할 만한 질문 (source)
2015-04-09 16:53:47 +0200 질문에 답변하였습니다 Single Column to Rows

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

Not an elegant solution, but quick enough.

2015-04-09 08:30:09 +0200 받은 배지  인기있는 질문 (source)
2015-04-08 23:32:52 +0200 질문하였습니다 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