Creating a Pivot Table where column names such as Occupation, Amount, Status, and Reference Number are selected

[RobertRussell_Monsalud]

Good Day.

I am trying to create a Pivot table in a new sheet inside the excel file with the following features:

This is the working file:
SampleExcelFile.xlsx (18.4 KB)

May I know what is the most efficient way to automate this process in a fast way especially when dealing with large number of data? What are the activities that should be used?

Thank you so much.

Best regards,
Robert

[vrdabberu (Varunraj Dabberu)]

Hi @RobertRussell_Monsalud

Check the below xaml file:

Sequence16.xaml (11.3 KB)

Regards

[RobertRussell_Monsalud]

Hi @vrdabberu

It worked. Thank you so much for your help. I will enjoy doing automation using UiPath. Thank you.

Best regards,
Robert

[vrdabberu (Varunraj Dabberu)]

You’re welcome @RobertRussell_Monsalud

Will be happy to assist you incase of any issues.

Happy Automation!!

[RobertRussell_Monsalud]

Hi @vrdabberu

I just have a follow up question. May I know what would be the most efficient way to include in column D the answer for the division of column B and Column C except for Grand Total?

Formula: B/C

Working File:
SampleExcelFile.xlsx (18.4 KB)

Working Workflow:
Sequence34.xaml (11.3 KB)

Sample desired output:

Thank you so much.

Best regards,
Robert

[vrdabberu (Varunraj Dabberu)]

Hi @RobertRussell_Monsalud

Check the below flow:

Sequence16.xaml (12.2 KB)

Regards

[RobertRussell_Monsalud]

Hi @vrdabberu

Is there a code or formula that can be used to exclude the last row which is shown below?

Thank you.

Best regards,
Robert

[vrdabberu (Varunraj Dabberu)]

Hi @RobertRussell_Monsalud

Check the below flow:

Sequence16.xaml (20.8 KB)

Regards

[RobertRussell_Monsalud]

Hi @vrdabberu

It worked. Thank you so much for your help. I really appreciate it.

Best regards,
Robert

[vrdabberu (Varunraj Dabberu)]

I’m happy to assist you @RobertRussell_Monsalud

Happy Automation !!