Promote specific row to header

[kylekumm]

Hi, 

I am working on a learning project and am in the process of cleaning the data. How would I make a specific row the header, as opposed to the first row? In this case, I would like row 18 to be the header row. Any help would be much appreciated!

 

[Ashish_Mathur]

Hi,

This M code replace the header with the entries in row 3 of the table

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    Colheaders = List.Zip({Table.ColumnNames(Source),Record.ToList(Source{2})}),
    Originaltable = Source,
    #"Renamed Columns" = Table.RenameColumns(Originaltable,Colheaders),
    #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each ([Name] <> "Name"))
in
    #"Filtered Rows"

[Ahmedx]

what should I do with the lines above line 18, delete them?