Forum Discussion
In Excel, how do you rearrange a specific range of columns (of a given row) into separated rows?
If you have the Current channel of O365, you should be able to use WRAPROWS:
If not, you could try something like this:
Note that the third parameter of INDEX represents the column indices in the row you are trying to reshape. So, regardless of the values in that row, if you pass the index-structure into that parameter, it will wrap the row as required.
Note that in my culture, comma is the array column separator while semi-colon is the array row-separator.
If you have the Current channel of O365, you should be able to use WRAPROWS:
If not, you could try something like this:
Note that the third parameter of INDEX represents the column indices in the row you are trying to reshape. So, regardless of the values in that row, if you pass the index-structure into that parameter, it will wrap the row as required.
Note that in my culture, comma is the array column separator while semi-colon is the array row-separator.
- Thank you so much, your solution is sublime!
