Can someone help me to built bot that creat a table that sums up the amount under same reference number?

Dear Guru
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

Hello @diana.dai!

It seems that you have trouble getting an answer to your question in the first 24 hours.
Let us give you a few hints and helpful links.

First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic.

You can check out some of our resources directly, see below:

  1. Always search first. It is the best way to quickly find your answer. Check out the image icon for that.
    Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.

  2. Topic that contains most common solutions with example project files can be found here.

  3. Read our official documentation where you can find a lot of information and instructions about each of our products:

  4. Watch the videos on our official YouTube channel for more visual tutorials.

  5. Meet us and our users on our Community Slack and ask your question there.

Hopefully this will let you easily find the solution/information you need. Once you have it, we would be happy if you could share your findings here and mark it as a solution. This will help other users find it in the future.

Thank you for helping us build our UiPath Community!

Cheers from your friendly