Reverse an Unpivot

[Anonymous]

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

[JoseEravuch1995]

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

[Anonymous · Accepted solution]

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