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 be the header row. Any help would be much appreciated!

 

Need Help

2 Replies

  • 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"

     

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

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