Excel crosstabulation solution

Copper Contributor

Hi, I have a very large Cross table with many combinations (catefogircal variables in both colums and rows). How can I create an simple output summery of the different unique combinations (categorical variable - row + categorical variable column) and their frequencies? (again it is a very big table with many variables so it is a nightmare and not practical to do it and screen the table manually). 

 

Appriciate your help!

Thank you very much!

0 Replies