itsmevic
asked on
Excel 2010: Pivot Table
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER