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
Icon for Super User rankSuper 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.