AppleScript for transposing only a range

You can try the script below. It will transpose values but won't convert formulas.

SG

--Select range, run, paste transposed values where wanted

set text item delimiters to tab

tell application "Numbers" to tell front document to tell active sheet

set selTable to first table whose class of selection range is range

tell selTable

set mySelection to selection range

set firstCol to address of first column of mySelection

set lastCol to address of last column of mySelection

set firstRow to address of first row of mySelection

set lastRow to address of last row of mySelection

set pasteStr to ""

repeat with i from firstCol to lastCol

set strRowLst to {}

repeat with j from firstRow to lastRow

copy (value of cell j of column i of selTable) to end of strRowLst

end repeat

set pasteStr to (pasteStr & strRowLst as text) & return

end repeat

end tell

end tell

set the clipboard topasteStr

display notification "Ready to paste transposed values" with title "Numbers"