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

kristen_qlik_noob — Wed, 09 Jan 2019 17:44:52 GMT

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%

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

zzyjordan — Wed, 09 Jan 2019 23:28:30 GMT

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

ZZ

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

kristen_qlik_noob — Fri, 11 Jan 2019 21:38:08 GMT

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

topic Help with creating table with frequency rows from columns in Excel. in App Development

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

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

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