Forum Discussion
excel table
I have a 1x57 table that i want to convert to 4x15. how do i do that
2 Replies
With modern Excel, use WRAPCOLS
To turn a 1×57 row into a 4×15 table, use this formula in a 4-row by 15-column area:
=INDEX($A$1:$BE$1, (COLUMN()-1)*4 + ROW())
Enter normally (Excel 365+) or with Ctrl+Shift+Enter (older versions). This fills the table by columns.
