If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I make columns independent of each other?
I am using Excel 2007 with survey results and would like to sort them by
question. There are 6 worksheets of data: one per campus with approximately 50 questions in the survey and 40 replies per campus. It is too cumbersome to manually perform all these steps. I have the questions separated by column and the answers are numerical ratings. I would like to sort these answers by column independently without regard for the other columns. I would also like to determine the percentage of those who answered 1, 2, 3, etc. Is there any way to do this? Thanks, teacher2010 |
#2
|
|||
|
|||
how do I make columns independent of each other?
Sometimes key thoughts behind analysis work lie in preparing the source data.
If source data is identically structured in each data sheet, just stack it all up into a single sheet with a single row of col headers. Do a manual copy n paste from each data sheet to stack it in any sequence, a couple of minutes effort will do it. Include a new col to differentiate the answers by campus, eg: Campus1, Campus2, etc. Easily drag to fill down the campus name from the 1st cell aligned with the 1st row of each data section after you paste it. Now you can easily do pivot table analysis on the combined source, or use formulas in another sheet to dissect/analyse the data -- Max Singapore --- "teacher2010" wrote: I am using Excel 2007 with survey results and would like to sort them by question. There are 6 worksheets of data: one per campus with approximately 50 questions in the survey and 40 replies per campus. It is too cumbersome to manually perform all these steps. I have the questions separated by column and the answers are numerical ratings. I would like to sort these answers by column independently without regard for the other columns. I would also like to determine the percentage of those who answered 1, 2, 3, etc. Is there any way to do this? |
Thread Tools | |
Display Modes | |
|
|