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
Anonymous's avatar
Anonymous
Not applicable
1 year ago

pankajnamekar25 Thanks it works till Step 6 but

 

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

 

I get error or maybe I am missing something. Thanks

pankajnamekar25's avatar
pankajnamekar25
Super User
1 year ago

Anonymous 

try this

[Qtr_Year] & " " & [Name]

 

Thanks,
Pankaj

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    pankajnamekar25 Unfortunately something is wrong with the logic.

     

    Code  Grp   Name Qtr_Year

    40023BGTQ1_2025
    40023BGTApple

     500    24     AVT  Q3_2024

     500    24     AVT  Orange

     

    Please refer to the above format and advise. Thanks