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?