Hi David,

Could you please re-check your requirement because i think you need to have a primary key.(l will proceed with the assumption that it is username)

then you can pivot...