Pivot Table with two row header?

  • Thread starter Thread starter sslack
  • Start date Start date
S

sslack

Can I create a Pivot Table using a combination of two rows as the
header?

Example:

Row B1 = May_05
Row B2 = June_05

A3 thru A10 = Dates

B3 thru B10 = Values

I want to establish B1 & B2 together is the header row. I need to do
this because C1 = May_05, C2 = Aug_05. My header is a pair of months.

Does anyone know if this is possible?

Thank You,
Steve
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1
Pivot table consolidation 1
repeating row group in pivot table 1
excel data table reformat 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Protecting user from changing previous data 5
Help in pivot 1
how to sum up a range of formulas? 5

Back
Top