Multiple Headings in Pivot Table

  • Thread starter Thread starter Liz
  • Start date Start date
L

Liz

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!
 
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.
 
Back
Top