Neither of the current connectors have this capability out-of-the-box. It is possible to do with a C# script though. It would certainly require some programming experience though. You can search for "C# Excel interop pivot table" and find some helpful code examples. You could use the Script component to write that code and have your automation call it.

Here is a post by someone else on the community that may help as well.

https://collaborate.pega.com/discussion/create-pivot-table-excel-script