Pivot table

Hi Charlene,

Thank you for your question and sorry for the delay in responding.

Open the spreadsheet and select any cell under the main headings. Go to Data and then the Pivot Tables option.

The wizard will then appear. Select excel database as the source and the Pivot Table option.

Then select the data source which must include all the headings and data source.

Finally tell excel where you want to place the pivot table. Then click Layout and choose which fields you want as Page, Row, Column and data.

Click OK and then Finish.

I hope this helps.

Regards

Simon