Dynamically promote column headers

[CJB246]

Hello,

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 🙂

Chris

[v-chuncz-msft]

@CJB246,

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"})

[CJB246]

Hi @v-chuncz-msft,

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