<div>
<div class="content wysiwyg-content">
Ok. Attaching what I have already. I would like powershell take the table in attachment 1, which is its own worksheet named &quot;AllServers&quot; , create a new sheet name with a pivot table from attachment 2. Is this even possible?<br />
<br />
Attachment 1<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/06_w24/659659/Attachment1.JPG" target="_blank" title="Attachment1 (88 KB)"><img alt="Attachment1" class="file-block lazyload" style="max-width: 461px;" data-src="https://filedb.experts-exchange.com/incoming/2013/06_w24/659659/Attachment1.JPG" /></a><br />
Attachment 2<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/06_w24/659661/Attachment2.JPG" target="_blank" title="Attachment 2 (51 KB)"><img alt="Attachment 2" class="file-block lazyload" style="max-width: 147px;" data-src="https://filedb.experts-exchange.com/incoming/2013/06_w24/659661/Attachment2.JPG" /></a>
</div>
</div>


Attachment1.JPG

Attachment2.JPG

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


Powershell with Excel Pivot Table

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.