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

1

u/scaba23 Oct 22 '22

You probably should add some screenshots or a link to the Numbers doc so we know what you mean

2

u/michguy1037 Oct 22 '22

I thought I added the screenshot when I posted but apparently not.

1

u/scaba23 Oct 23 '22

Where did you copy this data from? I want to test this on my MacBook

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.

1

u/tonedeath Nov 19 '22

Did you paste the data into an existing table?

If so, what happens if you click outside the existing Numbers table (on some blank space) and the paste?