Good Morning,

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.

Try this post.