Hi, I've reorganized my data using crosstab to obtain the orientation below. There are categories, the users for those categories and the amount of times they've used the category.
Category | U1 | U2 | U3 |
A | 1 | 3 | 0 |
B | 0 | 1 | 0 |
C | 3 | 0 | 2 |
I would like to do something to the above data to obtain the following table:
Category | Users |
A | U2, U1 |
B | U2 |
C | U1, U3 |
Notice they are in order of who has the most user (this is not absolutely necessary if too difficult)
Thanks in advance for the help.
Solved! Go to Solution.
.Edited
Works great. Thank you kindly