Currently all the responses in table are formatted so the questions are across the top, with the respondents listed down the left side. Do you know how I can flip this so the respondents names are across the top, with thier responses running down the list. I am using this for evaluations and I have more questions than respondents, it would be easier to view this way, and I cant flip it in excel either without alot of effort.
I also would like to freeze the line with Respondents name so as I scroll through the table, it stays put.
Thanks for your help!
It sounds as though the Detail view (accessed via the View > Detail View menu item in the View Responses tab) would work for you.