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))
Option 1:
=WRAPROWS(A1:A999,3)
If WRAPROWS is not available:
=INDEX(A1:A999,SEQUENCE(333,3))
THANKS!. The INDEX option works perfectly!