Dynamically promote column headers

Question

Hello,&nbsp;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?&nbsp;eg please see example below:&nbsp;&nbsp;&nbsp;How would I set the MS word in this example as a header?&nbsp;Thanks in advance :)&nbsp;Chris&nbsp;

v-chuncz-msft · Answer

CJB246,
&nbsp;
You may take advantage of&nbsp;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 · Answer

Hi&nbsp;v-chuncz-msft,&nbsp;Thanks for your help, I'm getting a stuck on an error do you know what is causing this?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Dynamically promote column headers

2 Replies

Related content

Power Query Promote Headers Dynamically

Promote Headers via dax or not use function Promote headers

Dynamic Column headers

How do I promote headers except one column?

Promote Headers on Selected Columns