Forum Discussion
Solved
In Excel, how do you rearrange a specific range of columns (of a given row) into separated rows?
The transpose function converts an entire row into one single column. This is not my goal. I want to reallocate a fixed range of columns (within a given row) into rows. For instance, suppose I have t...
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 for your help ^^