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.

 

[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?

 

[Gzero]

Put on hold, grrr need cmd permissions.