Help transform data structure better by power Query (multiple rows Headers)

Help transform data structure better by power Query (multiple rows Headers)Follow
Hai Huynh
Hai HuynhOct 12, 2022 06:55 AM
Dear All, I have a date structure as below: Each Product has a SaleNumber and a RecipeNumber. It includes …
1. Help transform data structure better by power Query (multiple rows Headers)

Hai Huynh
Posted Oct 12, 2022 06:55 AM | view attached
Dear All,

I have a date structure as below:
Each Product has a SaleNumber and a RecipeNumber. It includes multiple ingredients: A, B, C, D, E (each ingredient has a code)

I want to use Power Query to unpivol, transform to my structure better and logic more (sorry for my EN skill).
May you help me!

Thank you!

——————————
Hai Huynh
——————————
Attachment(s)

xlsxFormula.xlsx

2. RE: Help transform data structure better by power Query (multiple rows Headers)

Bronze Contributor
James Watts
Posted Oct 13, 2022 03:34 AM
Could you clarify what output you want ? And will the source file always have the same number of columns ?

——————————
James Watts
Business Intelligence Analyst
——————————

3. RE: Help transform data structure better by power Query (multiple rows Headers)

Adam Artur Boltryk
Posted Oct 13, 2022 11:51 AM
Hi Hai,

SaleNumber1, 2 and 3 you should have in measure at least from different source.
Recipe 1, 2, 3 you should kick to DIM table and make relation.

Than on column ‘NEW CODE’ just remove empty.

Regards,

——————————
Adam Artur Boltryk
Business Analyst
——————————