Forum Discussion

CJB246's avatar
CJB246
New Member
8 years ago

Dynamically promote column headers

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 ...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

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's avatar
    CJB246
    New Member
    8 years ago

    Hi v-chuncz-msft,

     

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