I would like to take 25 cells from a column (25 rows of data from that column) and
paste it into another sheet but have it pasted across in a row instead of in a column
as it was originally. So, I would end up with a new row, 25 columns wide.
Is there a simple way? At the moment, I have to copy and paste each cell individually?
Thanks,
Tony.
Mac Pro/MacBoo Pro, Mac OS X (10.6.3), Mac Since Late September '09
Tony,
You could use the TRANSPOSE function, but OFFSET would work as well.
Jerry
Jerry,
I looked up transpose and offset in Numbers help as well as
a PDF copy of the user guide and still cannot find how to re-arrange
copied/pasted data.
Transpose seems to be a command used in charts. Rather than actually
converting column data into row data, it appears to change the way column
and row data is used in a chart.
If I'm missing the point, you have my permission to knock some sense into
me ;-)
Thanks,
Tony.
Tony,
Here are examples with the two methods...
OFFSET:
TRANSPOSE:
Jerry
Many thanks and I appreciate your patience.
I'll give this a shot and let you know how it goes.
Tony.
There is an alternate scheme available.
Go to my iDisk :
<http://public.me.com/koenigyvan>
Download :
For_iWork:iWork '09:for_Numbers09:Transpose.zip
Expand it to get several scripts.
I guess that at least one of them would fit your needs.
Yvan KOENIG (VALLAURIS, France) mercredi 27 avril 2011 10:55:03
Tony,
I see I gave you a row to column example and you asked for a column to row solution. They are the same solution, but I should have been more careful in my example.
Jerry
I was adding some comments to the previous post when the server went down and I'm just getting back to this.
Here are full transposition examples:
These two methods are identical in the results they deliver, just a difference in the functions used to get there. The expressions in the destination table just read the displayed content of the original table. You then have to Copy and Paste Values to do anything useful with the result because you don't want to be carrying around that set of equations.
Yvan's Applescripts deserve your attention. At least one of them offers the advantage of moving the formulas around so you can work on a table with calculations and not have to redo the formulas.
I post the built-in Numbers Functions method because it's my opinion that if deserves mention even if it's not the best option. Secondly, not everyone is comfortable with scripts. And lastly, if you're just moving data and labels, not formulas, the scripts offer less advantage to the infrequent user.
Jerry
How do I copy data from a column and paste it into a row?
