I have a spreadsheet of survey responses with the question at the top of the column and the cells below the question containing numbers where users rated their interest. At the bottom of the column I have the sum formula, e.g.:
Question 1 Question 2 2 7 3 9 5 11 10 27 (the totals)I want to re-arrange this data into a horizontal format that shows the total and the question, so...
Question 1 10 Question 2 27If there an efficient way to do this? That is better than copying and pasting each cell? I've tried auto-fill in and can't make it work.
Thanks in advance for any suggestions you can give to make this process easier!
-Ken