Pivot - adding more alternatives

[Frustrated_with_excel]

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?!

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

 

[GlennUK]

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.

 

[Frustrated_with_excel]

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.

 

[GlennUK]

And does a pivottable of the data not give you that?

 

[Frustrated_with_excel]

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

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....

 

[Frustrated_with_excel]

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]

Can you actually show a sample of your data?

 

[Frustrated_with_excel]

unfortunatly, no..

The company I work for does not want this information to be shown to any external personell.

 

[GlennUK]

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?