To start with, you need to fix up your database.
Month should be in a single colum for each record (for example in col 'A')
NOT as a column heading.
Column Headings (IN ROW 1) should be 'Corporate Ending Customers',
'Corporate Gross Adds', 'Employee Ending Customers', 'Employee Gross Adds'.
Now your data is fit for pivot tables.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Liz" wrote:

How would I create a pivot table when rows 1 - 3 are the same but for months
December - June and for several accounts in column A?

December
Corporate Employee
Ending Customers Gross Adds Ending Customers Gross Adds
3M COMPANY 123 0 854 22

Any assistance would be appreciated!