Reprocess Excel to another Table Format

#1

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
ss1

After processed
ss2

Thank you in advance

#2

Hi @yjunkang

Use this link [Create Pivot table using UIPATH]

#3

Hi,

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