I'm working on some items for an audit and I have a very simple table, it only has 2 fields, they are Name and SamaccountName. Basically the Name field gives me the username of a person and the SamaccountName gives me the group that their AD accounts has.
My problem is there is a record for each samaccountname.
So let's say I user John Doe. If he had 3 security groups associated with his Name he would have 3 records:
John Doe Domain Admin
John Doe Domain Users
John Doe Administrator
I was wondering if there was a way to take this information and make it read like this:
John Doe Domain Admin; Domain Users; Administrator
Any help you can provide me if greatly appriciated.