transpose columns and rows in numbers

WARNING: When pasting back in to numbers, apparently it can only handle a hundred or so columns at a time. So I had to do this piecewise. Make sure all your data is there.

beckminsterfullerene wrote:

(Also BTW I tried to do that "services" thing to add the function to Numbers, but it didnt work.)

Well, that "service" thing worked well while it was needed. But this is a REALLY old thread. In Numbers 3 it's just a simple menu pick.

SG

"Here's the easiest way yet - just do it on a google spreadsheet."

How is copying, pasting special to a Google spreadsheet, copying again from there and pasting into Numbers easier than the procedure below, posted by SG March 3rd, is response to Duncan Parks?

"In the current version of Numbers all you have to do is click in the table and choose 'Transpose Rows and Columns' from the Table menu.

SG"

EDIT: ...and repeated immediately above.

Regards,

Barry

Sweet! Worked great. Thank you for this :-)

Hi jalbe,

This thread is really old. Suggest you start a new thread, stating your question and the version of Numbers you are using.

SG

Oh, have they finally fixed it? I gave up on Numbers in 2014. 😝

Transpose Rows and Columns was added years ago.

SG