How to transpose data pasted from a PDF sales table

bullpen7979 · Newbie Joined: 17 Jul 2012 Posts: 1

Greetings listers,

Hoping this can be done. I have a PDF table with sales data. Properly formatted in OOC,
It would occupy the range of (approximately) A1:O29.

When I copy and paste, all the data shows up in column A.

Not sure if there is a way to tame the way the data fall into place here. In excel, normally the transpose function is what I need. Any help?

karolus · OOo Advocate Joined: 22 Jun 2011 Posts: 208

Hallo

Select Column A and try →Data→Text_to_Columns

Karo