Transposing Summarize's 'SUM' Output

[bonadoni95]

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

[TheOC · Accepted solution]

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 solution]

Whoops - forgot to attach, please find below :) 

[messi007 · Accepted solution]

@bonadoni95,

Please see below : 

Attached the workflow.

Hope this helps !

Regards,

[binuacs · Accepted solution]

@bonadoni95 

[bonadoni95]

Thank you all for the responses! @binuacs @messi007 @TheOC

Really appreciate these solutions! Will look into it and come back should I found any problem.

Cheers!

Bona