View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Pivot Table - how do I add a column?

Not that I'm aware of.

"ajnmx" wrote:

I have a data table with a column of data called "durations" with value
from 1 to 14, but some are missing (there's no 6 or 13). On my pivot
table I want the column headings to be the numbers 1 to 14 without the
missing figures. I know I could add these as dummies to the data
table, but can I somehow force them to appear on the pivot table
directly?