Data Import and unPivot

[msc7808]

Hi There

I am new to PowerBI. My source data is sample sales breakdown of various categories. 

I would like to unpivot and organize information vertically. Given few tries but didn't have success so far.

Can someone please share their insight into this?

Thanks

Manny

[v-jingzhang]

Hi @msc7808 

Daniel has provided a perfect solution. You can copy his code into Advanced Editor to add a new step and replace "PreviousStep" with the last step name in your APPLIED STEPS pane like #"Changed Type". 

How to add a step or steps to an existing power query - YouTube

Best Regards,
Community Support Team _ Jing

[wdx223_Daniel · Accepted solution]

NewStep=#table({"ID","Category","Quantity"},List.TransformMany(Table.ToRows(PreviousStep),each List.Split(List.Skip(_),2),(x,y)=>{x{0}}&y))