transpose |
@all | Apply to all cells in the table. |
cell | Cell identifier. You can identify cells using either the column letter and row number (e.g., “A1”), or by using “R” followed by the row number, followed by “C” and the column number (e.g., “R1C2”). |
row[,] col | Row number, followed by column letter or number, separated by “,” (e.g., “2,C”, or “2,3”). Apply to cell. |
row | Row number (e.g., “2”). Apply to all cells in the row. |
col | Column letter (e.g., “B”). Apply to all cells in the column. |
first_cell[:]last_cell, first_cell[,]last_cell | Top left cell of the selection range (specified in “cell” format), followed by bottom right cell of the selection range (specified in “cell” format), separated by a “:” or “,” (e.g., “A2:C10”, “A2,C10”, or “R2C1:R10C3”, “R2C1,R10C3”). Apply to all cells in the rectangular region defined by the first cell and last cell. |
first_cell_row[,] first_cell_col[,] last_cell_row[,] last_cell_col | Top left cell of the selection range (specified in “row[,] col” format), followed by bottom right cell of the selection range (specified in “row[,] col” format), separated by a “,” (e.g., “2,A,10,C” or “2,1,10,3”). Apply to all cells in the rectangular region defined by the first cell and last cell. |