Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Pivot or Unpivot?

Hi All,   I have in power query the following table   Code  Grp   Name Qtr_Year 400 23 BGT Q1_2025 400 23 BGT Apple   Now I want the below output Code  Grp   Name Qtr_Year Ctgy...
Need Help
Tips and Tricks
Ashish_Excel's avatar
Ashish_Excel
Solution Supplier
1 year ago

Hi,

This M code works

let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Code ", "Grp ", " Name"}, {{"Count", each Text.Combine(_[Qtr_Year],"")}})
in
    #"Grouped Rows"

Hope this helps.