I want to create a process I have a table and make a pivot out of it. I already know that I have to transform it into the table format and use the “Create Pivot Table” activity. My concern is that I want to create the pivot in a new sheet because the original sheet has to stay in the way it is with no extra data. So how is it possible to create a pivot with the data of Sheet1 in Sheet2?
Hopefully you can help me out