PIVOT TABLE Help Please
in [General]
|
Prev: highlight the row of the cell Im working in?
Next: How do you randomly assign numbers without getting duplicates?
From: Roger Govier on 6 Apr 2010 13:15 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. -- Regards Roger Govier Judi wrote: > 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 > > > "trip_to_tokyo" wrote: > >> 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. >> >> >> >> >> >> "Judi" wrote: >> >>> 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 |