Pivot or Unpivot?

Hello Anonymous 

You can achieve this in Power Query by using Group By and Text.Combine. Here's how:

Steps in Power Query

1. Load your data into Power Query.
2. Select the "Code" and "Grp" columns, then go to Transform → Group By.
3. In the Group By window:
• Group by: Code and Grp
• New Column Name: Merged_Name
• Operation: All Rows
4. Click OK → this will create a grouped table.
5. Click on the small icon in the grouped column to expand the "Name" and "Qtr_Year" columns.
6. Create a custom column using this formula:

powerquery

CopyEdit

Text.Combine([Qtr_Year], " ") & " " & Text.Combine([Name], " ")

This merges the values from both columns into a single row.

1. Remove unnecessary columns if needed.
2. Click Close & Load to return the transformed data to Excel or Power BI

Thanks,
Pankaj

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.