Reorganize data after crosstab

[tylerj]

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.

[alexnajm · Accepted solution]

Transpose, Filter, Sort, and Summarize should do it! Here's a workflow:

[Raj]

.Edited

[tylerj]

Works great. Thank you kindly