Powershell: Compare 2 columns with non-unique data

Dane Briggs 211 Reputation points

I have been tasked to write a script to import a CSV and determine if each user logs into a laptop, desktop or both. Some users log into multiple computers. I have a CSV of users and computers that they log into. How do I search through a column of the CSV that has duplicates and pull the data from another column and change the output? I feel like I am missing something simple

Example CSV

Example of request output

Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,455 questions
{count} votes