Pivot Table for survey data w/ questions as Rows & poss answrs as
Hi,
I'm trying to use a Pivot Table to present some survey results, and could use a point in the right direction. Details: -------- - The first question is "what department do you work for?" - The rest of the questions all have the same possible answers (agree, strongly, disagree, strongly disagree). - The questions are the column headings in the source data set. In the Pivot Table, I'm looking to: ----------------------------------- - have the rows be the individual questions (col headings from data set) - have the columns be the four possible answer (col data from data set) - have the data be the occurence of the possible answers for each of the columns - be able to split out and/or compare the answers by department. Is this possible using Pivot Tables? I tried having the Department be the PT's "Page Field" and various combinations of placing the other fields in the Row Fields, Column Fields & Data Fields, but to no avail. It doesn't seem to want to let me have mulitple rows of questions; instead it seems to want to make me have separate Pivot Table's for each question. Could anyone give me a pointer or two in the right direction? Thanks in advance for any help, :)Ben |
All times are GMT +1. The time now is 10:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com