How can i create pivot table without macro

I have a pivot table in excel with a full file, my process dipatch this full excel file on multiple file but i need to have a pivot table according to the new dispatching file.


There are uipath activities for this task but they’re not sufficient.
you will have to use macro to create a pivot table.

Here I have a Video with code of how I create Pivot Tabel: