transpose columns and rows in numbers
I need to transpose columns and rows in Numbers and I do not want to write script to do it. Is there an easier way?
MacBook Pro, iOS 6.1.4, iWork - Numbers
Your fix for getting it to work in Numbers 2 didn't quite work. Here's the version that worked in Numbers 2:
--Transpose - select range, run, paste transposed values where wanted
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
set first_col to the address of the first column of the selection range
set last_col to address of last column of the selection range
set first_row to address of first row of the selection range
set last_row to address of last row of the selection range
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
on error
display dialog "Select a range first and then try again"
end try
--end script
It didn't seem to like assigning the variable my_selection to be the "selection range." Maybe it has to be declared in some way. I just dispensed with the assignment and it worked. Thanks, this will save some time in creating a mailing list using Numbers.
"She who knows not and knows not that she knows not is a fool, spurn her. She who knows not and knows that she knows not is a child, teach her. She who knows and knows not that she knows is asleep, wake her. She who knows and knows that she knows is a fanatic, kill her." -- ancient proverb