Transposing Summarize's 'SUM' Output

Question

Hello everyone!

A question about transposing. I would like to transform this data (combined four Summarize's 'SUM' output by using Join Multiple):

To become like this:

I have tried using the transpose tool, but it does not allow me to transpose without having any key columns.

Really appreciate your help on this one.

I also attach the excel file for your reference.

Regards,

Bona

Summary Output.xlsx

TheOC · Accepted Answer

hi @bonadoni95

I have created what you need by applying a record ID, then transposing, using the record ID as my key column:

Please find attached the workflow.

Cheers,
TheOC

TheOC · Accepted Answer

Whoops - forgot to attach, please find below :)

messi007 · Accepted Answer

@bonadoni95,

Please see below :

Attached the workflow.

Hope this helps !

Regards,

binu_acs · Accepted Answer

@bonadoni95