Hi Team,
Could you please help me with the attached excel, to convert the Input into output file with with transpose function.
Regards
MM
Thanks Buddy, this works but what if we have 20+ such scenario then we need to use Transpose 20 times or is there any other way to solve this, something Dynamic that we can use.
@ManuMittal
First of all, we need to understand the logic for transpose?
What will be difference for some columns to be "Type" column, some columns go to "Amount".
Maybe a bigger dataset would help.
Hi @ManuMittal,
As @Qiu said it's a little difficult to create the dynamic transpose without knowing what defines your key fields and fields to be transposed. In this case, as an example of how you could create a dynamic transpose i've assumed all numeric data type fields should be transposed. We can then achieve the dynamic output with the help of dynamic select tools to determine the fields that should and should not be transposed.
I've attached my workflow for you to download if needed.
Kind regards,
Jonathan