Open the world of Pivot Tables

  • Thread starter Thread starter Debster
  • Start date Start date
D

Debster

I have been using pivot tables for quite some time now, and in my opinion the
world of pivot tables can be expanded greatly by the opportunity to allow
"alpha" data to be reported back in the values section. I know -
unconventional, but see example below:

Raw Data:

NAME CITY PROVINCE
GEORGE TORONTO ON
PAULA VANCOUVER BC
FRANK REGINA SK
SAM MONTREAL QC
TYLER SUDBURY ON
BRITTANY ST. JOHN NF
BILLY CHARLOTTETOWN PEI

Pivot table layout:
Column label: Province
Row label: Name
Value City

Requested results

Province
Name BC NF ON PEI QC
SK
Billy Charlottetown
Brittany St. John
Frank
Regina
George Toronto
Paula Vancouver
Sam
Montreal
Tyler Sudtury


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...3-78b4d594fded&dg=microsoft.public.excel.misc
 
You must log in or register to reply here.

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

Similar Threads

Pivot table displayed by day of the week 3
Help with Selecting Ranges in Pivot Table 3
Updating tables 2
Updating table 3
Pivot Table result appends the numeral 2 to values excel2002 4
Pivot table crashing after the install of KB973475 3
No. of columns in a Pivot Table 1
pivot table label adding "2" to the end of a label name 7

Back
Top