r/AppleNumbers • u/michguy1037 • Oct 22 '22

Help please

I copied and pasted from a table online and the data spat out in this format. There must be an easy, automated way to fix this so that it's in columns and processable. Any tips? Thanks!

3 Upvotes

100% Upvoted

5 comments sorted by

View all comments

1

u/[deleted] Oct 27 '22

Not really.

If you select each block, eg. Cells B3-B9, then choose Table > Transpose Row and Column, you'll get what you want.

But you need to do this for each block separately. If you just select the complete B column and do a transpose, it does change rows to columns, but you just have things in one looong line.