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% |
