Link to home
Start Free TrialLog in
Avatar of pbo1
pbo1Flag for United States of America

asked on

How do you pivot data where you do not need to sum data

In the attached spreadsheet I have data that I need to pivot by store number, but I do not need to sum values.  My initial thought was to group the data, but that wont work since I need to see the store results horizontally.  

Any thoughts

 ee-pivot.xls User generated image User generated image
Avatar of dlmille
dlmille
Flag of United States of America image

Is this what you're looking for?
User generated imageDave
ee-pivot.xls
if you click on the above pic, it will resolve to something that's viewable.  Also look at the attached spreadsheet, above.

Dave
Avatar of pbo1

ASKER

2 questions dlmile:

What does the sumvalues in the column labels do
What is the value called "data" in cell d3 do

ASKER CERTIFIED SOLUTION
Avatar of dlmille
dlmille
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pbo1

ASKER

Excellent dlmile !