Transform - unpivot table

Hi All

I am new to the Power Query concept and would appreciate some help/guidance.

Situation, I have a table of inventory/products which have some deliverables at various stages that I want to be able to visualize in a more presentable way. I have made a simplified sample of what I need some help with. The colour codes are only to show how I anticipate the data to be "transformed"

Steps
•Basic product table (excel) with deliverables; the deliverables availability, state and hour estimation/progress
2019-08-12, Product presentation 0.JPG

•For making the sorting by deliverables (1: Sales, 2: Standard ...) I have made some "manual" transformation to visualize the result that I am after see last picture

2019-08-12, Product presentation 1.JPG

Can this be managed by Power Query?

Any Help would be appreciated

Regards
Kari

Hi

Please see attached file, only a small sample of a larger dataset

Regards
Kari

Small manual error in the Category column (Small for all Product 1, Medium for all Product 2 ...)

Thanks for the promt reply, it is highly appreciated.

I can see that there is a lot of work to do with my original dataset (I have deliverables from 1:... to 32:...)

Hi

Thanks for the various solution suggestions. I used your solution as sample for my general dataset, allthough I used Power BI Query Editor for my manipulation (The split column by Lowercase to Uppercase). Not available in my excel version... (Splitter.SplitTextByCharacterTransition({"a".."z"}, {"A".."Z"})

Please Login or Register  to view this content.

Regards
Kari

Thanks for the kind words... 90% was your solution. I learned from the best

The splitter is not in my Excel version. Noted that this computer that i am using now has version 2016... I have to check with IT-dept