Consolidated License Listing

Question

Hello,

Our data population is a list of users with multiple licenses across multiple boards, etc.. Each user has multiple records (one for each license). How can we best summarize to have one row per unique user with the licenses added as multiple columns? Not sure what we're doing wrong, but Transpose isn't working. Help! Thanks so much in advance.

apathetichell · Answer

tile tool - unique value on distinct username. cross tab - with tile sequence number as your column and the license field as your value. mode as concatenante (comma seperated - not this field must be text). run.

alexnajm · Answer

Crosstab will take your toes and create headers, one for each unique value in the column you select (in this case, the license column)!