Transpose and Sum

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,

Expected.xlsx

Actual.xlsx

Data Investigation

Accepted answers

kelvin_law1

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:

All comments

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

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703