Brief explanation:

I manage an AD, and from time to time I need to pull the users from specific groups for audit compliance. I'd like to be able to run a script that dumps out a CSV that I can then email to those who need it. I'd like the table to look a little like this:

Group1                           Group2                                    Group3
---------                           ---------                                    ----------
James                             Jon                                          Ralph
Don                                Daniel                                      Carroll
Carroll                            Paul
Paul                                Donald
                                      Mark
                                      Luke

I've managed to pull this off pretty effectively by directly writing it to an Excel file:

$Excel = New-Object -ComObject Excel.Application $Excel.visible = $True $Excel = $Excel.Workbooks.Add() $Sheet = $Excel.WorkSheets.Item(1) $Sheet.Cells.Item(1,1) = "User Revalidation" $WorkBook = $Sheet.UsedRange $WorkBook.Interior.ColorIndex = 8 $WorkBook.Font.ColorIndex = 11 $WorkBook.Font.Bold = $True $List = Get-Content groups.txt $Groups = $List | Get-QADGroup $intRow = 2 $intCol = 1 ForEach ($item in $Groups) { $Sheet.Cells.Item($intRow,$intCol) = $item.name $member = Get-QADGroupMember $item $intRow = $intRow +1     foreach ($item2 in $member)     {        $Sheet.Cells.Item($intRow,$intCol) = $item2.name        $intRow = $intRow +1     } $intRow = 2 $intCol = $intCol +1 } $WorkBook = $Sheet.UsedRange $WorkBook.EntireColumn.AutoFit() Clear

One way to solve a problem never satisfies me. Is there a way to pull this off using custom objects so I can just export directly to the CSV?

CSV is not a good way to store the data the way you want.

You could create objects with MemberName and GroupName properties and then create a CSV file that looks like this:

MemberName,GroupName
James,Group1
Don,Group1
Carroll,Group1
Paul,Group1
Jon,Group2
Daniel,Group2
Paul,Group2
Donald,Group2
Mark,Group2
Luke,Group2
Ralph,Group3
Carroll,Group3

Or using pretty formatting

MemberName   GroupName
----------   ---------
James        Group1
Don          Group1
Carroll      Group1
Paul         Group1
Jon          Group2
Daniel       Group2
Paul         Group2
Donald       Group2
Mark         Group2
Luke         Group2
Ralph        Group3
Carroll      Group3

To get column names to be the group names you would need to

1. create objects that have the all the group names as properties
2. each object would contain 3 unrelated people (one per group)
3. when you run out of people for a given group you need to stop putting people in that group's property but still need to create a new object because at least one of the remaining groups will have a member

Ugh! I'm having a hard time explaining what it would take to format it the way you want to show it.

In any case, most of your code is excel management code or formatting and a CSV has neither of those. Perhaps it is best to keep your excel code.