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

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 can tell it to ignore the NULL rows and just set the first non NULL record to column header?

 

eg please see example below:

 image.png

 

 

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

 

Thanks in advance Smiley Happy

 

Chris

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Dynamically promote column headers

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

 

 header2.PNG

 

 

header.PNG