Move Column Contents in Power Query

[AllisterB]

I have headers in trow 1 that are the targets
The row below that has similar headers but in a different order.
I need to move the contents of the columns (row3 down) to sit under the most appropriate Header.

What is the best approach?

201.xlsx
	H	I	J	K	L
3	Part Number	Name	Price	Material	Size
4	Size	Part #	Name		Price
5	Large	SJD-23	Wheel		10
6	Small	KLJ-26	Bolt		5
Sheet1

Thanks

Allister

 

[sandy666]

post an example of the result you want

 

[AllisterB]

See attached

201.xlsx
	H	I	J	K	L
3	Part Number	Name	Price	Material	Size
4	Size	Part #	Name		Price
5
6
7
8	RESULT
9	Part Number	Name	Price	Material	Size
10	SJD-23	Wheel	10		Large
11	KLJ-26	Bolt	5		Small
Sheet1

 

[sandy666]

Original
Part Number	Name	Price	Material	Size
Large	SJD-23	Wheel		10
Small	KLJ-26	Bolt		5
Helper table
Part Number	Name	Price	Material	Size
Size	Part Number	Name	Material	Price
Result
Part Number	Name	Price	Material	Size
SJD-23	Wheel	10		Large
KLJ-26	Bolt	5		Small

let
    Tbl1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Helper = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    Append = Table.Combine({Helper, Tbl1}),
    Promote = Table.PromoteHeaders(Append, [PromoteAllScalars=true]),
    TSC = Table.SelectColumns(Promote,{"Part Number", "Name", "Price", "Material", "Size"})
in
    TSC