Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Reverse an Unpivot

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

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I played with this a little more and using Pivot now works. Unsure what changed, but problem solved.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I played with this a little more and using Pivot now works. Unsure what changed, but problem solved.

  • JoseEravuch1995's avatar
    JoseEravuch1995
    Regular Visitor
    3 years ago

    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 [email protected]

     

    Thank you