Showing results for 
Search instead for 
Did you mean: 
CJB246 Frequent Visitor
Frequent Visitor

Dynamically promote column headers



I'm trying to set first row to a column header but when new data is added (a new column) there's null values until the new column name. How do i set this new column name/ is there a way i can tell it to ignore the NULL rows and just set the first non NULL record to column header?


eg please see example below:




How would I set the MS word in this example as a header?


Thanks in advance Smiley Happy




Community Support Team
Community Support Team

Re: Dynamically promote column headers



You may take advantage of Table.FillUp.

    #"Filled Up" = Table.FillUp(Source, Table.ColumnNames(Source)),
    #"Kept First Rows" = Table.FirstN(#"Filled Up",1),
    #"Removed Top Rows" = Table.Skip(Source,1),
    #"Appended Query" = Table.Combine({#"Kept First Rows", #"Removed Top Rows"})
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CJB246 Frequent Visitor
Frequent Visitor

Re: Dynamically promote column headers

Hi @v-chuncz-msft,


Thanks for your help, I'm getting a stuck on an error do you know what is causing this?