Demo-SecurityMatrix.ps1

#region Create GroupMember Hashtable
$csvMatrix = @"
UserID	APP-MS Excel	APP-MS Outlook	APP-MS Powerpoint	APP-MS Visio Viewer	APP-MS Word	APP-Adobe Reader
ejboogers	1		1	1	1	1
dlbouchlaghmi	1	1	1	1	1	1
sideroij	1	1	1	1	1	
barnhoorn			1	1	1	1
bofechter	1	1	1			1
asschonewille		1		1	1	1
rrchouiter	1	1		1	1	
mgragt	1	1	1	1	1	
tpggrimbergen			1	1		1
bvanderhassel	1	1	1	1	1	1
jvderwilk	1	1		1	1	1
cdvanderheijden	1	1	1	1	1	1
thvjanssen		1	1	1		1
skalac-ivor	1	1		1	1	1
nvanderspeklap		1	1		1	1
mkrunder	1	1	1		1	
nkoelewijk		1	1	1	1	1
jlekkerkernij	1	1		1		1
"@ | ConvertFrom-Csv -Delimiter "`t" 

$csvMatrix | 
Sort-Object -Property UserID |
Format-Table

$Header = $csvMatrix | 
   Get-Member -MemberType NoteProperty | 
   Where-Object{$_.Name -ne  'UserID'} | 
   Select-Object -ExpandProperty Name

$addADGroupMembers = @{}
$delADGroupMembers = @{}

$Header |
ForEach-Object{
   $Group = $_
   $addADGroupMembers.$Group  = $csvMatrix.Where{$_.$Group -eq '1'} | Select-Object -ExpandProperty 'UserID'
   $delADGroupMembers.$Group = $csvMatrix.Where{$_.$Group -ne '1'} | Select-Object -ExpandProperty 'UserID'
}
#endregion

#region Security Matrix
$Groups = $addADGroupMembers.Keys
function Convert-ArrayToHash($a){
    begin { $hash = @{} }
    process { $hash[$_] = $null }
    end { return $hash }
}

$template = [PSCustomObject]([Ordered]@{UserID=$null} + $($Groups | Convert-ArrayToHash))

$arrMatrix = @()

$Groups |
ForEach-Object{
   $GroupName = $_
   if($addADGroupMembers.$_){
      $addADGroupMembers.$_ |
      ForEach-Object{
         if($arrMatrix.Count -eq 0) {
            $newItem = $template.PSObject.Copy()
            $newItem.UserID = $_
            $newItem.$GroupName = '1'
            $arrMatrix += $newItem
         }
         else{
            if($arrMatrix.UserID.contains($($_))){
               $index = [array]::IndexOf($arrMatrix.UserID, $_)
               $arrMatrix[$index].$GroupName = '1'
            }
            else{
               $newItem = $template.PSObject.Copy()
               $newItem.UserID = $_
               $newItem.$GroupName = '1'
               $arrMatrix += $newItem
            }
         }
      }
   }
}

$arrMatrix | 
Sort-Object -Property UserID |
Select-Object 'UserID', 'APP-MS Excel','APP-MS OutLook','APP-MS Powerpoint','APP-MS Visio Viewer','APP-MS Word','APP-Adobe Reader' |
Format-Table
#endregion