Forum Discussion
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...
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.
pankajnamekar25 Unfortunately something is wrong with the logic.
Code Grp Name Qtr_Year
| 400 | 23 | BGT | Q1_2025 |
| 400 | 23 | BGT | Apple |
500 24 AVT Q3_2024
500 24 AVT Orange
Please refer to the above format and advise. Thanks