Q: transpose columns and rows in numbers
-
Dec 14, 2014 3:36 PMby Eltham Jones,Yep, after several years of ignoring all the Mac users who were telling them "YES! we do want a transpose function" and Apple making lame excuses because they stupidly forgot to include it (but will never admit to the fact that they got something wrong), they have finally given us the function that we have been asking for all these years.
And guess what? Now it's a "Great New Feature!"...
-
Nov 18, 2015 8:48 AMby Rau Arbeitsschutz,Hello SG III
still using numbers (2.0.3) and your transpose script.
So is it possible with you script to transpose the formular of the cells and not the values. For example: "='Tabelle 1-1-1' :: B2"
Thanks for your answer
PS
- Transpose - select range, run, paste transposed values where wanted
--SGIII 2014.05,v2 and 3 https://discussions.apple.com/thread/6237667?tstart=0
try
tell application "Numbers" to tell front document to tell (first sheet whose every table's selection range's class contains range)
set selected_table to first table whose class of selection range is range
tell selected_table
tell the selection range
set first_col to address of its first column
set last_col to address of its last column
set first_row to address of its first row
set last_row to address of its last row
end tell
set str to ""
repeat with i from first_col to last_col
repeat with j from first_row to last_row
set str to str & (value of cell j of column i of selected_table) & tab
end repeat
set str to str & return -- add line return after row
end repeat
end tell
end tell
set the clipboard to str
display notification "Ready to paste transposed values" with title "Numbers"
on error
display dialog "Select a range first and then try again"
end try
--end of script
TT
-
Nov 18, 2015 9:42 AMby SGIII,Rau Arbeitsschutz wrote:
still using numbers (2.0.3) and your transpose script.
So is it possible with you script to transpose the formular of the cells and not the values. For example: "='Tabelle 1-1-1' :: B2"
Hi Rau,
It is possible. I understand one of Yvan Koenig's scripts does this in Numbers 2. But it is too complicated for me. Recommend moving to Numbers 3.
SG
-
Jun 6, 2016 1:44 PMby beckminsterfullerene,Here's the easiest way yet - just do it on a google spreadsheet.
As long as you have a google or gmail account this works.
Go to docs.google.com. Click the menu button and open a new spreadsheet.
Right click on a cell. Paste special -> paste transpose
that will work, now copy and paste back into numbers.
(Also BTW I tried to do that "services" thing to add the function to Numbers, but it didnt work.)
