If I have a data like this:
| Column A |
|---|
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
What formula should I use if I want it to look like this in spreadsheet?
| Column A | Column B | Column C |
|---|---|---|
| 1 | 2 | 3 |
| 4 | 5 | 6 |
| 7 | 8 |
Thank you!
I want to transform my long data into a table view with defined row and column.
New contributor
Ayu Eka is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
You need WRAPROWS() function.
<code>=WRAPROWS(TOROW(A:A,1),3,"")
</code>
<code>=WRAPROWS(TOROW(A:A,1),3,"")
</code>
=WRAPROWS(TOROW(A:A,1),3,"")
1