Split multi value column into multiple record PowerShell

Question

Hi everyone. I would appreciate any help.
I have a column with multiple values in PowerShell and I want to split them into multiple records. In my case I can do it only in PowerShell and then I am going to export it in CSV.

Answer 1

Assuming you're working with a CSV you've exported from that spreadsheet:

Import-Csv "your-csv-here.csv" |  
    ForEach-Object {  
        $name = $_.Name  
        $_.MemberOfGroups -split ";"|  
            ForEach-Object{  
                [PSCustomObject]@{  
                    Name = $name  
                    MemberOfGroups = $_  
                }  
    } | Export-Csv "new-csv-here.csv" -NoTypeInformation  

If you're working from an Excel spreadsheet you can install the ImportExcel PowerShell module and change the 1st line from "Import-Csv" to "Import-Excel".