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

     

slorin's avatar
slorin
Super User
1 year ago

Hi jerryr125 

 

= Table.FromRows(
      List.Skip(Table.ToRows(Source), 2),
      List.Transform(
         List.Zip({Record.ToList(Source{0}), Record.ToList(Source{1})}),
         Text.Combine))

Stéphane