You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
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
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
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:
Numbers Transpose
