Help with creating table with frequency rows from columns in Excel.

[kristen_qlik_noob]

Hey everyone, hopefully you all can help! I am having difficulty with getting a table in this format. Essentially in Excel I have columns with questions dealing with Brand Associations. So Column 1 has answers 1 - 5. Each answer on there associates with a company. 

So for example if they answered 1 = Company 1. 2 = Company 2. 3 = Company 3. 4 = Company 4. 5 = Company 5. 

I was wanting to make a simple frequency row(s) where it displays the percentage of people that selected 1, 2, 3, 4, 5. 

Hopefully looking something like this : Is there any way to do this? 

Survey Question	Company 1	Company 2	Company 3	Company 4	Company 5
Brand Association Question 1 (Column A)	82%	8%	2%	2%	6%
Brand Association Question 2 (Column B)	18%	10%	3%	5%	64%
Brand Association Question 3 (Column C)	11%	12%	4%	7%	66%

[zzyjordan]

Hi, Kristen
Can you provide a sample data in Excel for better understanding of your case?

ZZ

[kristen_qlik_noob · Accepted solution]

Hi ZZ, I think I have solved this one with Crosstables.