Pivot - adding more alternatives

Joined
Mar 17, 2011
Messages
5
I have a problem here guys.

I have a worksheet that contains data from 7 different drop down lists.

One of these drop down lists is in 10 different columns. And another is in 6 different columns.
I would like to add all of them to my pivot table, to analyse the data collected from 526 different question forms.

How to do this?! :confused:

Or is there another, better way of doing this? Please help!
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
I think you'll have to give more information about what your data consists of, and what your pivottable will look like, and what you want to do with the pivottable.
 
Joined
Mar 17, 2011
Messages
5
Information consists of age, location, sex of recipient, their job role, then 10 fields of their level of satisfaction with their job, and then 6 fields of what they feel can be different.

I would like the Pivot table, or something else that helpes me analyze it, can be changed to view a certain age group in a certain job role that is males from the eastern seaboard, and their level of satisfaction. As an example.

So i need a whole lot of different things that I can change, as I wish to view different compositions of variables.
 
Joined
Mar 17, 2011
Messages
5

ADVERTISEMENT

Please keep in mind, when it comes to Excel, I am probably legaly retarted.:eek:

So far, I can only seem to add 3 different variables at a time. So I can see their age, where they are located, and wheter they are males of females. But not their level of satisfaction in the different areas of their work, their job role and so on....
 
Joined
Mar 17, 2011
Messages
5
Another problem is that when I try to view it chart with columns, it seems like it doesn't want to give it any values. So instead of completely satisfied, I perhaps should have given it a value, like 5 down to 1 for not satisfied at all. But, I didn't do it the first time.

Please do NOT tell me I have du put all the data back in to a new sheet one by one....
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402

ADVERTISEMENT

Can you actually show a sample of your data?
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
Can you show me an example of what contents you have in what columns, without showing any actual personnel names ... use Fred Bloggs or whatever?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,507
Messages
5,523,310
Members
409,511
Latest member
hitesh222002

This Week's Hot Topics

Top