Forum Discussion
changing format of data in a worksheet from horizontal to vertical
Can anyone tell me if there is a way to automate changing the format of the planning sheet I have attached? This is just a test so you can see what I need to do. I currently have 730 Part Numbers that I plan - months out horizontally - but we are moving to a new system that needs the data to be entered vertically. Thanks for your help!!
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).
2 Replies
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).