Forum Discussion
changing format of data in a worksheet from horizontal to vertical
You should use the "unpivot" function in Power Query.
1. Turn your data into a table (select it and hit CTRL T).
2. Load to PQ. With your table selected, under the Data tab, select "from table/range"-this will load the table to PQ.
3. Right click the RR Planning Key column and choose "unpivot other columns".
4. Close and load to a table.
Done-see attached.
To look at the steps I did, launch the PQ Editor (select Get Data, then launch PQ editor).
You should use the "unpivot" function in Power Query.
1. Turn your data into a table (select it and hit CTRL T).
2. Load to PQ. With your table selected, under the Data tab, select "from table/range"-this will load the table to PQ.
3. Right click the RR Planning Key column and choose "unpivot other columns".
4. Close and load to a table.
Done-see attached.
To look at the steps I did, launch the PQ Editor (select Get Data, then launch PQ editor).