Calc Guide

6) Click OK.
Figure 151: DataPilot dialog
7) The result appears on a new sheet. It has the desired structure,
but the columns are not yet grouped into months.
Figure 152: DataPilot result without grouping
8) To group the columns, select cell B4 or any other cell that
contains a date. Then select Data > Group and Outline >
Group. On the Grouping dialog (Figure 153), make sure Intervals
and Months are selected in the Group by section, and click OK.
The result is now grouped for months (Figure 154).
222 OpenOffice.org 3.x Calc Guide