changing format of data in a worksheet from horizontal to vertical

[MEW_1009]

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!!

[#2 · Accepted solution]

@MEW_1009 

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).

[#3]

Thanks so much@DhaniCole !  This has solved my issue.  I really appreciate your response!!