PIVOT TABLE Help Please

J

Judi

I have an Excel 07 table. It has a vertical column of names and then
horizontal headings of organization, software, version, if it's licensed, and
a few other things. I'd like to create a pivot table that shows me all the
names on the left (sorted into respective groups), and then the headings at
the top of software names and versions. The data I'd like to show up in the
table is whether or not it's licensed.

PLEASE PLEASE help me!! Thank you.

Judi
 
T

trip_to_tokyo

Judi, the type of info that you give does not lend itself very well to the
construction a Pivot Table.

You need to give more details about what your columns contain.

You seem to have the following columns:-

Names
Organization
Software
Version
Licence?

What is in these columns? Numbers or text?

You are not really providing enough info for people to come up with a
meaningful response.

Do you really need a Pivot Table? Maybe something else would be better?
 
T

trip_to_tokyo

Judi, I have just put up an example of a Pivot Table at:-

http://www.pierrefondes.com/

Item number 86 (towards the top of my home page at the time of posting).

It has been prepared for another person (you can see what their problem is
in the Workbook) but I hope it will help you out.

There are other examples of Pivot Tables on my web site. To find them hit
Ctrl-F in your web browser and then just type in:-

pivot

- in the Search Window that should launch. There are 14 matches that you
might like to have a look at. I hope that there is something in there that
will help you out.

If my comments have helped please hit Yes.

Thanks.
 
J

Judi

Thanks everyone. Here is the DETAILED problem in question:

Column:
A - Name
B - Org
C - Computer Name
D - Compter Property Number
E - Software/Program
F - Version
G - Licensed Y/N
and then some other junk I don't really need.

There are 1400 rows, and I'm looking at the best way to present (in the
following order, but maybe with expandable portions, 1) the program, 2) the
version and 3) whether or not it's licensed. I want to tie each item (if
expanded) to its respective name in Column A.

Any ideas? This one's a little complex for me. Usually, I'm pretty good at
this stuff!!

HELP!

Judi
 
R

Roger Govier

Hi Judi

Drag Software to the Row labels area, followed by Version and then Name
drag Licensed to the Column labels area
Drag Licence again, to the Values area as Count of Licensed.

When you click on the "+" of Program, it will "open" to show the
versions. If you click on the "+" of Version, you will see the names
associated.

Alternatively, right clicking on a cell within the PT, will give you the
option of Expanding or Collapsing whole fields.

You can add more of your fields as required, just add htem below the
others in the Row labels area.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top