If you want to format your data in a certain way, you have to present it to PowerShell in the way it expects it. You need to create an object that has a property for each group, holding the username for that group..
When adding these objects to an array, PS knows what to do with it:
$list = @("ExternalCitrixDefault","ExternalUserGroup")
# Prepare AD data variables
$data = New-Object PSCustomObject
$maxcount = 0
# Get all the Userdata from AD
foreach ($item in $list) {
$data | Add-Member -MemberType NoteProperty -Name $item -TypeName Array -Value ""
$data.$item = Get-ADGroupMember -Identity $item | Select-Object -Property Name
# Keep track of the maximum itemcount
if ($maxcount -lt $data.$item.count) {
$maxcount = $data.$item.count
}
}
# Prepare the Output Array
$output = @()
# Loop through all the lines
for ($i=0; $i -lt $maxcount; $i++) {
# Prepare the Object to hold the line of Users
$userline = New-Object -TypeName PSCustomObject
# Fill the Userline Object with values for line $i
foreach ($item in $list) {
$userline | Add-Member -MemberType NoteProperty -Name $item -TypeName Array -Value $data.$item[$i].Name
}
# Add the userline to the Output Array
$output += $userline
}
# Display the Output Array
$output | select -Property $list |ft -AutoSize
$items = foreach ($item in $list) {
Get-ADGroupMember -Identity $item | select @{Label=$item;Expression={$_.Name}}
}
$items | ft
