Excel transform records to column

Associate
Joined
6 Dec 2008
Posts
2,341
Location
Scotland
Hoping someone can see an easy solution to this, been bugging me all day.
I have this:
34zee5h.png

and I want to transform it to this:
1zqy5aw.png

Any ideas?

I'm pulling the information from an AD dump that I lazily put together to just spit out a csv file.
 
Last edited:
Associate
OP
Joined
6 Dec 2008
Posts
2,341
Location
Scotland
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? :D
 
Soldato
Joined
8 Nov 2006
Posts
21,678
Location
London
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.
 
Last edited:
Top Bottom