SOLVED

Split/transpose/transform cells in single column by every 3rd cell into 3 columns.

Copper Contributor

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...

 

 

3 Replies
best response confirmed by VI_Migration (Silver Contributor)
Solution

@bweiss1111 

 

Option 1:

=WRAPROWS(A1:A999,3)

 

If WRAPROWS is not available:

=INDEX(A1:A999,SEQUENCE(333,3))

@Patrick2788 

THANKS!. The INDEX option works perfectly!

1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

@bweiss1111 

 

Option 1:

=WRAPROWS(A1:A999,3)

 

If WRAPROWS is not available:

=INDEX(A1:A999,SEQUENCE(333,3))

View solution in original post