I need to transpose a single column of text made of 100 rows and would like
it to output into 4 columns with 25 rows in each. when I use the transpose under
Table I get 1 row with 100 columns. Is there a way to set the output - columns/rows?
iMac 27″, macOS 11.4
It doesn't sound like you want to "transpose". That is exchanging rows and columns. You can easily rearrange the data into 4 columns x 25 rows by Cut/Pasting.
If you have formulas that refer to any of those 100 cells, do it this way instead:
It doesn't sound like you want to "transpose". That is exchanging rows and columns. You can easily rearrange the data into 4 columns x 25 rows by Cut/Pasting.
If you have formulas that refer to any of those 100 cells, do it this way instead:
You could try something like this:
Your one column of 100 values in the first table, which has one header row.
In A2 of your second table (which also has one header row) input this formula and copy-paste or fill it down and to the right:
=INDEX(Table 1::$A,ROW()+10*(COLUMN()−1))
SG
Numbers Transpose
