Would like to turn table of data into another table of total counts, need to define X and Y Axis

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Flair (click to view more posts with a particular flair)

Solved

Post Body

Edited for clarity.

Have a table of data:

PC Name	Windows Version	Site
NameA	Windows 10 1703	Texas
NameB	Windows 10 1703	Florida
NameC	Windows 10 1709	Texas

I can Select-Object -Property Name,Count and get a total count of one variable down a linear list.

Name	Count
Windows 10 1703	2
Windows 10 1709	1

What I'd like to do is turn it into a table counting across both X and Y axis for example.

Feed $Var_WinVer & $Var_Site

Version	Site:Texas	Site:Florida
Windows 10 1703	1	1
Windows 10 1709	1	0

I have tried googling, but the majority of what I find deals with data in arrays and outputting tables as a linear list like I already have. Nothing I can find to define a 2nd $Var as the header of the table.

Edit2:

I should correct myself by saying I'm running Group-Object $Var_WinVer | Select-Object -Property Name,Count

Author

Account Strength

90%

Account Age

9 years

Verified Email

Yes

Verified Flair

Total Karma

4,174

Link Karma

215

Comment Karma

3,959

Profile updated: 3 days ago

Posts updated: 3 days ago

williamt31

Subreddit

r/PowerShell

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 5 years ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/PowerShell/...