"Rotating" / Pivoting / tranforming Data
 

I've tried researching various techniques, but without luck. I'm
trying to take a table like this:


Login Server Role

bob Server01 Admin
david Server01 User
charlie Server02 User
david Server02 Admin
alice Server03 User
bob Server03 User
david Server03 Admin

(etc .. with over 50 servers)

to this:


Login Server01 Server02 Server03 Server04 (etc ... etc...)
------- -------- -------- -------- --------
alice User
bob Admin User
charlie User
david User Admin Admin


Ideally, I don't want to pre-define the Server01,02, etc columns in
advance.......


Any suggestions on doing this? I'd prefer to do this without
MACROS/VBA if that is possible.

A full write up isn't needed, just a good pointer if one exists
already. I've come close with pivots, but only seem to be able to get
computational data in the data section.


Thanks!