Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
pivot tables for likert-scale type survey items
98 views
Skip to first unread message
kk
Jul 9, 2007, 8:06:04 PM7/9/07
to
My data are arranged so that each row (or column, transposed) consists of a
question, and the data are 1-5 point (strongly agree to strongly disagree)
words (or values). I want a table that has each question in a row and each
of the values in a column. I've worked for 3 hours, no luck. Any help out
there?
question, and the data are 1-5 point (strongly agree to strongly disagree)
words (or values). I want a table that has each question in a row and each
of the values in a column. I've worked for 3 hours, no luck. Any help out
there?
Roger Govier
Jul 12, 2007, 5:16:51 AM7/12/07
to
Hi
If you are saying the questions are currently in row 1, each question in
a new column, with rows 2 to 6 containing the answers, then mark the
whole set of data, Copy, move to another sheet and place the cursor in
cell A1, Paste Special>Transpose
--
Regards
Roger Govier
"kk" <k...@discussions.microsoft.com> wrote in message
news:83989618-B83F-4AA6...@microsoft.com...
kk
Jul 12, 2007, 9:58:06 AM7/12/07
to
Thanks, Roger. This isn't quite it, but I'm now using a workaround.
0 new messages