Forum Discussion
Forms Responses in Excel are hard to read
Hi there,
I have a form that I'm trying to submit to clients with roughly 80 questions on said form. I'm trying to avoid making them sign up for an email/username through microsoft, so I've included a "First and last name" question to sort the responses. My questions is, with 80 questions and 200 some clients, when I display the responses in excel it's very difficult to view them client by client (Because each response is on a different line and I have 80 columns to scroll through). Is there some formatting I can do to individualize the responses. Or even a table option that will allow me to view one form response at a time? Thank you.
2 Replies
- Logaraj SekarIron Contributor
Hi,
If you want all responses (which is in horizontal) in vertically in one page, I think pivot table will help you.
If this is not you expected, please put screenshots of what you have and what you want.
- Logaraj SekarIron Contributor
Hi Caleb Ramage,
If you want all responses (which is in horizontal) in vertically in one page, I think pivot table will help you.
If this is not you expected, please put screenshots of what you have and what you want.