Excel transform records to column

[Gzero]

Hoping someone can see an easy solution to this, been bugging me all day.
I have this:

and I want to transform it to this:

Any ideas?

I'm pulling the information from an AD dump that I lazily put together to just spit out a csv file.

 

[muon]

Just use IF commands with cell references?

IF(cell=criteria,"x","")

 

[Gzero]

Just use IF commands with cell references?

IF(cell=criteria,"x","")

Thanks for the suggestion.

I've also got the headache of taking all the records to switch them across to side column. Any idea how I can grab them all, prune duplicates then use the if criteria?

Edit: I'm thinking I'm just going to have to output a second csv file and do the formatting manually. Excel can prune duplicates right?

 

[muon]

Well I was thinking of something like this, where in Sheet 2 we have

output group1 group2 group3
user1
user2
user3

and use

B2=IF(ISERROR(VLOOKUP(Sheet2!$A2,Sheet1!A:A,1,FALSE)),"","x")

Since that will lookup the first value that will ignore duplicates anyway, but you still need to populate Column A (without duplicates) in Sheet 2.

I can't think of something which would easily output that.

 

[Gzero]

Put on hold, grrr need cmd permissions.