Custom Hierarchy

[H_insight]

Hi All,

I am trying to achieve the below hierarchy in PQ, but not getting much success. Any chance of help?

Expected outcome:

Sample file link.

Many thanks

[bharat_kumar · Accepted solution]

Hey
I have tried the same and achieve the hierarchy you have mentioned.
please find the Screenshots for your reference.

Let me describe you the Applied Steps:

1. Unpivot the Type column
2. Pivot the value column by keeping Attribute in value dropdown.
3. Use Headers as First Row.

4. Remove the Bottom row (1).
5. Rename the Column names as per your levels,
6. Sort the columns as required.

Please like the solution if you got success.

[H_insight]

@bharat_kumar 

Any chance of sharing the working files please? You can use this free site to upload it. thanks "https://easyupload.io/!

[bharat_kumar]

Please find the attached file.

https://easyupload.io/mtdbx7