Formating excel data

please help me to sort this excel in proper format using uipath activities
input file

wanted output

please help me with this

First try to format it using excel feature “Pivot Table” manually. You can find it in Insert menu of Excel.

If you will be able to do it using Excel’s Pivot Table. You can replicate the same thing in UIPath using Send Hotkey and Click actives.

Please describe in detailed steps the actions you need to take.

For example:

  1. Delete columns
  2. Filter rows where column y = “abc”
  3. Aggregate rows based on x field
  4. Add total to the bottom of column c