Sorry to ask what is probably an easy question. I am a moderately experienced Excel user and recently moved to OpenOffice (love it!). I'm sure the solution to this question is in many places but it is a bit difficult for me to describe but here goes...
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 27
If 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