Power Query - Promot Headers except the first two columns

[Omer_K]

Hello everyone,
I have several files that I group using Power Query,
The problem is, the first two columns have their title in place while the other columns I have to promote the first row as a title ..
I did not find any option to promote only some of the columns ..
Any Ideas?

 

[RoryA]

You can't promote some of the columns. You could do the whole first row and then rename the first two columns?

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    tcn2 = List.FirstN(Table.ColumnNames(Source),2),
    tcnlast = List.Skip(Record.ToList(Source{0}),2),
    Result = Table.FromRows(List.Skip(Table.ToRows(Source),1),tcn2 & tcnlast)
in
    Result

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Col1	Col2	Column3	Column4	Column5	Column6	Column7		Col1	Col2	Col3	Col4	Col5	Col6	Col7
2			Col3	Col4	Col5	Col6	Col7		30	22	24	12	39	29	1
3	30	22	24	12	39	29	1		27	28	40	2	13	26	23
4	27	28	40	2	13	26	23		11	42	37	32	35	9	38
5	11	42	37	32	35	9	38		17	25	41	33	6	10	16
6	17	25	41	33	6	10	16		4	14	15	19	21	18	8
7	4	14	15	19	21	18	8		20	5	34	36	7	31	3
8	20	5	34	36	7	31	3
9
Sheet2

 

[GraH]

along the same idea of @JGordon11

let
    Source = Excel.CurrentWorkbook(){[Name="data"]}[Content],
    RenamePartial = Table.RenameColumns(Source, List.Zip( {List.Skip(Table.ColumnNames(Source),2), List.Skip(Record.ToList(Source{0}),2)} )),
    RemoveRow1 = Table.Skip(RenamePartial,1)
in
    RemoveRow1