Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
My goal is to do the reverse of an unpivot.
Input:
After unpivoting, I have the following table -
Index | Attribute | Value
0 | CategoryA | AA
0 | CategoryB | BB
1 | CategoryA | CC
1 | CategoryB | DD
Desired Result:
I would like to reverse the unpivot so that I have the following table -
Index | Category A | Category B
0 | AA | BB
1 | CC | DD
Any ideas on how to do this? I tried using pivot and selecting don't summarize but it tells me there are too many rows.
Thanks,
Buri
Solved! Go to Solution.
I played with this a little more and using Pivot now works. Unsure what changed, but problem solved.
Hi,
You can use the pivot option in the transform ribbon. Select the category column and click the pivot option.
Hope it is helpful. for more, you can reach out to joseeravuchira@gmail.com
Thank you
I played with this a little more and using Pivot now works. Unsure what changed, but problem solved.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |