Splitting Column with different headers

[Connor_H]

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!

[serpiva64]

Hi,

instead of an image can you post sample data

[Connor_H]

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

[serpiva64 · Accepted 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!