I made a normal table on Excel, now I need to create a Pivot Table by using UIPATH. I got the short key like: Alt + V + N then Enter; however, I have not idea about how to modify the Pivot Table setting (ie. check on the column boxes) in order to build up the new table.
In this case, I’d like to move the “Credit/Debt” column into [Columns], “Country” column into [ROWS], and “Sum of Amount” into [VALUES].
Lastly, I also need to copy/paste the built Pivot Table to a new sheet.
Many thanks !Pivot_Table.xlsx (13.2 KB)