Excel 2010: Pivot Table
Posted on 2013-06-24
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>
Thanks for your help!