Set str to str & return- add line return after rowĭisplay notification "Ready to paste transposed values" with title "Numbers"ĭisplay dialog "Select a range first and then try again" Set str to str & ( value of cell j of column i of selected_table) & tab Set last_row to address of last row of my_selection Set first_row to address of first row of my_selection Set last_col to address of last column of my_selection Set first_col to address of first column of my_selection Set selected_table to first table whose class of selection range is range Tell application "Numbers" to tell front document to tell active sheet Transpose - select range, run, paste transposed values where wanted Then paste the following into the Run AppleScript action, replacing all text already there by default: In Automator choose File > New > Service, drag a Run AppleScript action from the left into the right pane, choose 'No Input' for 'Services receives selected' and 'Numbers' for 'in'. To use it (this is slightly different from Excel) you select the range you want to transpose, choose Copy Transpose, click a destination cell in an existing table in the current document or another document, and command-v (Edit > Paste) or option-shift-command-v (Edit > Paste and Match Style). Ok, here's a proper transpose, that can be placed in an Automator Service so it becomes a simple menu pick as below (and can also be assigned a keyboard shortcut). Give me a proper transpose and I will uninstall Excel and never look back.
0 kommentar(er)
