Forum Discussion
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...
Here's another solution you could refer to. Thanks
Hi jerryr125 , Could you please try this
- Promote the first row to headers: Use the "Use First Row as Headers" option.
- Combine the first two rows:
- Select both rows.
- Use the "Transform" tab > "Merge Columns."
- Select desired delimiter.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance