transpose columns and rows in numbers

Thanks. Very elegant little script which works perfectly.

I did everything, but I keep getting this error. What did I do wrong?

Select a range first and then try again

Can't believe I didn't see this sooner (your reply to Duncan). Super easy. Just didn't read everything like I should've. Thanks SG

Glad you got it sorted out.

SG

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.

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