Powershell with Excel Pivot Table

Ok. Attaching what I have already. I would like powershell take the table in attachment 1, which is its own worksheet named "AllServers" , create a new sheet name with a pivot table from attachment 2. Is this even possible?

Attachment 1
Attachment 2
Attachment 2
Who is Participating?
David Johnson, CD, MVPConnect With a Mentor OwnerCommented:
powershell knows nothing about pivot tables and an excel vba solution would be a much better fit.
Xytras1Author Commented:
Thanks for the Info.
All Courses

From novice to tech pro — start learning today.