Nov 22 2022 06:28 AM
All data is A1:A999.
Goal is to create 3 columns:
etc...
Nov 22 2022 06:47 AM
Solution
Option 1:
=WRAPROWS(A1:A999,3)
If WRAPROWS is not available:
=INDEX(A1:A999,SEQUENCE(333,3))
Nov 22 2022 06:55 AM
THANKS!. The INDEX option works perfectly!
Nov 22 2022 07:45 AM
Nov 22 2022 06:47 AM
Solution
Option 1:
=WRAPROWS(A1:A999,3)
If WRAPROWS is not available:
=INDEX(A1:A999,SEQUENCE(333,3))