Forum Discussion
Easy way to move column headings to row labels?
The operation you have described is transposing the dataset. The formula that will do this is
= TRANSPOSE( data )
but the formula must be committed with ctrl+shift+enter as an array.
You could alternatively perform the task manually using Cut and Paste transposed.
Power Query will transpose data as well as promoting and demoting headers to the first row of data.
Another formula that is capable of reversing rows and columns is INDEX in which a column number is read from a helper range ( or calculated from COLUMN() ) and then used as the row index in the function. Take your choice.
The operation you have described is transposing the dataset. The formula that will do this is
= TRANSPOSE( data )
but the formula must be committed with ctrl+shift+enter as an array.
You could alternatively perform the task manually using Cut and Paste transposed.
Power Query will transpose data as well as promoting and demoting headers to the first row of data.
Another formula that is capable of reversing rows and columns is INDEX in which a column number is read from a helper range ( or calculated from COLUMN() ) and then used as the row index in the function. Take your choice.