Reprocess Excel to another Table Format


Hi All,
I need help here. I have a table which is filtered from my raw data (pic 1).
I need to create a dynamically generated table and summarized the data like in pic 2.
Both row and column are dynamically generated based on pic 1 data.

1st Table

After processed

Thank you in advance


Hi @yjunkang

Use this link [Create Pivot table using UIPATH]



its working but I need to drag the field to relevant area. Is there any ways to automate the dragging part?