Can you please help me to built a bot that can simulate the function of Pivot table?
I tried Record Macro and the execute Macro activity before , but it’s not very ideal when data volume changes
the row data is attached below
rowdata.xlsx (175.5 KB)
In this file. there are multiple rows with same Document Number.
i want to get a table that sum up “Amount in doc. curr.” and “Amount in local currency” with same “Document number” respectively, along with some other columns shown which is also under same document number.
the outcome wanted is attached below
outcome wanted.xlsx (13.0 KB)
is it possible to create this table with DATA TABLE activities instead of pivot table in Excel?
screenshot of pivot table as below
Much appreciation in advance