Forum Discussion
Partially transpose a table
Click in the source range.
On the Data tab of the ribbon, in the Get & Transform Data group, click From Table/Range.
Select all the week columns.
In the query editor, activate the Transform tab of the ribbon.
Select Unpivot Columns > Unpivot Only Selected Columns.
If you don't want the week in the final result, right-click the column with the weeks and select Remove from the context menu.
Switch back to the Home tab of the query editor, and click Close & Load.
Click in the source range.
On the Data tab of the ribbon, in the Get & Transform Data group, click From Table/Range.
Select all the week columns.
In the query editor, activate the Transform tab of the ribbon.
Select Unpivot Columns > Unpivot Only Selected Columns.
If you don't want the week in the final result, right-click the column with the weeks and select Remove from the context menu.
Switch back to the Home tab of the query editor, and click Close & Load.
- Big thanks Hans!
