Forum Discussion

kylekumm's avatar
kylekumm
New Member
2 years ago

Promote specific row to header

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 b...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

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"