I'm sure this is something simple.
I'm using a pivot table to give total units and sales for an item number. I need then to each be in separate columns, but it lists them underneath each other. How do I get it to list the values in separate columns?
Thank you!
Adam
I'm not quite sure a pivot table can do this, so as an alternative, why not build a table yourself.
Your profile shows 2002, but your attachment suggests 2007+
The table in I:K is using SUMIF which is good with 2007+ and more efficient....
------------------------------------------------------------------------------
EDIT: Sorry just found the solution you seek.
http://www.techonthenet.com/excel/pi...a_cols2011.php
In the Row Labels >> Click on Values >> Move to Column Labels
Last edited by jeffreybrown; 09-16-2013 at 07:35 PM.
HTH
Regards, Jeff
To fix your pivot table, take the VALUES out of the Row Labels and move to Column Labels.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks newdoverman, you sure cleared that up. Couldn't have said it better myself...Originally Posted by newdoverman
I've got a trial version of 2013, but don't think I'm going to make the leap... so 2002 it is.
I moved row to column and that is a workable solution.
Thanks guys!
Thanks for the feedback.
Remember that with Excel, there is more than one way to "skin a cat".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks