I have data that looks like the attachment below. I want to sum the categories by state if there is an X in the category over to the right. I am not sure how to do this.
Solved! Go to Solution.
Hi @bsolove,
This could be achieved by first Transposing the table and then split the table to 2 and join them back together:
User | Count |
---|---|
59 | |
26 | |
24 | |
22 | |
21 |