Consolidated License Listing

[valeriemattas]

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. 

[alexnajm]

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

[apathetichell]

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.