Forum Discussion

UncleLewis's avatar
UncleLewis
Responsive Resident
5 years ago
Solved

Power Query Pivot Returns Integer Value Not Original String

Hi all, Using Excel 365. I imported data from Table into Power Query, UnPivoted, Replaced Column Names so now I only have 2 Names in Attributes and various Values in Values Column.   But when I...
Need Help
  • UncleLewis's avatar
    UncleLewis
    5 years ago

    Thanks HotChilli,

     

    I'll take a look at that, In the meantime, solved the problem using Conditional Column and a few additional steps. Solution using Conditional Column is here : https://tinyurl.com/4nd6rny4

     

    Thanks,

    -w

UncleLewis's avatar
UncleLewis
Responsive Resident
5 years ago

I have to rename the fields after the Unpivot - correct?

Power Query will not allow me to rename the columns and give the same name.

Beginning column names:

  • Code
  • PO#
  • Code2
  • PO2
  • Code3
  • PO3

Thanks,

-w

HotChilli's avatar
HotChilli
Community Champion
5 years ago

Er, no.

 

"So, before the Unpivot rename column Code as Code1 and PO# as PO1.

Do the Unpivot."