Combine 2 rows and promote them to header in power query

[milkywaypowerbi]

How do i combine 2 rows and promote them into header in power query as shown in yellow below?

[Hariharan_R]

Hi @milkywaypowerbi 

if you want to get the result like your screenshot in the report then you can try this in report side not on the Power Query side but still added you the refrencing link to combine multiple rows in to the header.

Ref - https://www.ehansalytics.com/blog/2021/6/12/working-with-multiple-row-headers-from-excel-in-power-qu...

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin