View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jac Jac is offline
external usenet poster
 
Posts: 58
Default How to group Columns in Pivot Table?

hi,

I have a list of data which the Time values are recorded as 1, 2, 3, 4, 5,
6.....0. & I have created a pivot table like below:-

Count of Total_carton Time
6 7 8 9 Grand Total
Total 20 16 3 52 91

But actually, I would like the Time column in Pivot Table look like
following:-

Count of Total_carton Time
6-7 8-9 Grand Total
Total 36 55 91

Is there any way to modify the data displayed in Pivot Table's column?

Thanks!