Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I am new to Power Query and I'm looking to reorganize this report but I'm running into the issue of splitting columns with different headers as show below.
Where I would like to have it set up like this.
Thank you for any help!
Solved! Go to Solution.
Hi,
you can obtain your result applying the steps of the attached file
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
Hi,
instead of an image can you post sample data
Item | Description | |||||||||||
111111 | Desciption 1 | |||||||||||
Customer | Invoice | Quantity | Unit | Sales Balance | Cost value | Margin | Contribution ratio | |||||
111 | Inv-01 | 1.00 | EA | 100.00 | 50.00 | 50.00 | 50.00 | |||||
Inv-03 | 2.00 | EA | 200.00 | 100.00 | 100.00 | 50.00 | ||||||
Inv-04 | 3.00 | EA | 300.00 | 150.00 | 150.00 | 50.00 | ||||||
Total | 600.00 | 300.00 | 300.00 | 50.00 | ||||||||
111222 | Description 2 | |||||||||||
Customer | Invoice | Quantity | Unit | Sales Balance | Cost value | Margin | Contribution ratio | |||||
222 | Inv-11 | 1.00 | EA | 100.00 | 50.00 | 50.00 | 50.00 | |||||
223 | Inv-12 | 2.00 | EA | 200.00 | 100.00 | 100.00 | 50.00 | |||||
Total | 300.00 | 150.00 | 150.00 | 100.00 | ||||||||
111333 | Description 3 | |||||||||||
Customer | Invoice | Quantity | Unit | Sales Balance | Cost value | Margin | Contribution ratio | |||||
333 | Inv-22 | 1.00 | EA | 100.00 | 50.00 | 50.00 | 50.00 | |||||
334 | Inv-23 | 2.00 | EA | 200.00 | 100.00 | 100.00 | 50.00 | |||||
Total | 300.00 | 150.00 | 150.00 | 100.00 |
This is the original set up of the data, below is the desired outcome
Item | Description | Customer | Invoice | Quantity | Unit | Sales Balance | Cost Value | Margin | Contribution Ratio |
111111 | Description 1 | 111 | Inv-01 | 1 | EA | 100 | 50 | 50 | 50 |
111111 | Description 1 | 111 | Inv-03 | 2 | EA | 200 | 100 | 100 | 50 |
111111 | Description 1 | 111 | Inv-04 | 3 | EA | 300 | 150 | 150 | 50 |
111222 | Description 2 | 222 | Inv-11 | 1 | EA | 100 | 50 | 50 | 50 |
111222 | Description 2 | 223 | Inv-12 | 2 | EA | 200 | 100 | 100 | 50 |
111333 | Description 3 | 333 | Inv-22 | 1 | EA | 100 | 50 | 50 | 50 |
111333 | Description 3 | 334 | Inv-23 | 2 | EA | 200 | 100 | 100 | 50 |