Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
3D pivot tabling
XL2003. Analysing surveys. A user has a large survey (fewer than a hundred
responses but loads of questions) of multichoice questions, each with multi answers, along the lines of "How many of these statements apply to you?" I'd like to analyse it with static data (respondents' sites, departments etc) and the various Q1 answers that were given, Q2 answers and so on. The only way I can see to do it (apart from VBA at which I am close to hopeless) is to turn one multichoice answer into several single answers, eg Respondent 1234 chose C, D, F and H for Q1, so turn that into four rows each starting with Respondent 1234. This is an uninviting task: please can you help me do it more cleverly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tabling a cube | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
selective output tabling | Setting up and Configuration of Excel | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |