Forum Discussion

jerryr125's avatar
jerryr125
Helper IV
1 year ago
Solved

Creating a header from the first two rows

Hi -  I know in Power Query you can "Use First Row as headers" function. Is there a way to use the first two rows as headers  (combine both rows  to create one header row). Example:   a b c...
Need Help
Tips and Tricks
  • SundarRaj's avatar
    SundarRaj
    1 year ago

    Here's another solution you could refer to. Thanks

     

dufoq3's avatar
dufoq3
Community Champion
1 year ago

Hi jerryr125, another solution:

 

Add this code as a new step, replace Source in code with your previous_step_name if necessary.

= Table.PromoteHeaders(Table.FromColumns(List.TransformMany(Table.ToColumns(Source),
        each {List.Skip(_, 2)},
        (x,y)=> {Text.Combine(List.FirstN(x, 2))} & y)))