Is there a way to group columns in an Excel pivot table using the ImportExcel PowerShell module?
I’m currently working on a PowerShell script that leverages the ImportExcel PowerShell module to create an Excel spreadsheet with data, then creating a pivot table from that data. I had manually created a sheet and pivot table manually from a report from a print management system that I manage, and I’d like to automate this task.