Forum Discussion
New2PowerBI
9 years agoHelper III
Difficulty in unpivoting Table
I would like to unpivot a table; but I can't seem to easily unpivot after following a couple of tutorials. I suspect it has to do with the data as it is, I think I need to clean it up some more. H...
- 9 years ago
1) Select Employee Name, Employee Number and Column 2 - Unpivot Other Columns
2) Select Column 2 - Pivot Column - Values Column select Value - Don't Aggregate
3) Rename Attribute Column (rearrange columns if you want)
Hope this helps! :smileyhappy:
dkay84_PowerBI
9 years agoMicrosoft Employee
**bleep** it Sean! You outdid me again! Plus a video... you're just showing off
Wow the word D A M N gets bleeped out?!
Wow the word D A M N gets bleeped out?!
New2PowerBI
9 years agoHelper III
Wow! Thank you!!! I knew it had to be a two-step "something" but just couldn't figure it out. I met with someone here at work yesterday for close to an hour and they couldn't figure it out. :-(
Amazing! Thank you!!! Loving the help and support in this community and looking forward to sharing with others! :-)