Formating excel data

Help
1

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

image
image1366×768 64.6 KB

wanted output
image
image1366×768 57.1 KB

please help me with this

2

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.

3

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