Solved

Excel 2010:  Pivot Table

Posted on 2013-06-24
2
375 Views
Last Modified: 2013-06-25
Hello Experts!

    Quick question.  Is it possible to pivot off a worksheet that has a blank column within the data that's being pivoted?  For example here is the format of my worksheet below:

Column C contains a calendar pop-up macro that allows you to select the appropriate date, it then populates that date in column B.   When I try and pivot the those columns I can't because of column C.   Take column C out of the equation and I have no problem pivoting the data.  Is there a way to pivot the columns yet exclude column C?

                       A              B                            C                                  D

3                  Task       Date                       Blank Column            Time      <<< Header Row>>>
4              Lockouts   6/24/2013       <date macro button>    3:10:32    <h.mm.ss>
5              Testing    6/24/2013       <date macro button>      1:23:04     <h.mm.ss>
6
7
8
9
etc.
etc.
                                                                 
Thanks for your help!
0
Comment
Question by:itsmevic
2 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 39272436
Why not just put a header in that column... the header will go into your Field list, but you don't have to actually put it in the Pivot table.
0
 

Author Closing Comment

by:itsmevic
ID: 39275690
Thanks.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My experience with Windows 10 over a one year period and suggestions for smooth operation
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now