Forum Discussion
Excel multiple columns to rows
Dear, I would kindly ask for help. I'm using Excel 2013. I have 16 columns and big numbers of rows (e.g. 300+) I would like that each row, would be placed next to the ending (16th) column. ...
Formula version:
Assuming your data is in $A$1:$P$3.
Puttting below formula in ColumnA, drag it to the right as far as your need.....
=INDEX($A$1:$P$3,INT((COLUMN()-1)/16)+1,MOD(COLUMN()-1,16)+1)
Assuming your data is in $A$1:$P$3.
Puttting below formula in ColumnA, drag it to the right as far as your need.....
=INDEX($A$1:$P$3,INT((COLUMN()-1)/16)+1,MOD(COLUMN()-1,16)+1)