Transpose and Sum

[RudrakshPandey]

Hi Everyone,

I am trying to transpose unique values in a column (column C) as column headers and then sum all the values corresponding to those in the column for different for all the unique values in column A.

Hope the attached actual and expected files help to explain what I am trying to achieve

Thanks,

R

[Qiu]

@RudrakshPandey 
A Cross Tab tool will just do the work.
Kindly check the sample flow of Cross Tab and give a try. 

[kelvin_law1 · Accepted solution]

Hi @RudrakshPandey 

You can simply use a Cross Tab tool to do that.  It works very similar to the PIvot Table function in Excel.  Here is how you can configure it for your sample data:

[RudrakshPandey]

Thanks Kevin and Qiu. That Worked!