Forum Discussion
Solved
Split/transpose/transform cells in single column by every 3rd cell into 3 columns.
All data is A1:A999.
Goal is to create 3 columns:
- A1:A3 > D1:G1
- A4:A6 > D2:G2
- A7:A9 > D3:G3
- A10:A12 > D4:G4
etc...
Option 1:
=WRAPROWS(A1:A999,3)If WRAPROWS is not available:
=INDEX(A1:A999,SEQUENCE(333,3))
3 Replies
Option 1:
=WRAPROWS(A1:A999,3)If WRAPROWS is not available:
=INDEX(A1:A999,SEQUENCE(333,3))THANKS!. The INDEX option works perfectly!
- You are welcome!
