Powershell Script to transpose rows into columns
A question was posted on Windows Powershell peer support forum that asked if array data can be transposed where a table rows can be transposed into columns:
I found this to be an interesting question and put this script to answer it. The script can be downloaded from the Microsoft Script Center Repository.
This script will take array input similar to the following which would be the content of .\table1.csv sample input file used in the script:
The script will transpose it by “Property”, grouped by “Server”, where intersection of Property X Server = Value. The result will look like: