ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table with two row header? (https://www.excelbanter.com/excel-discussion-misc-queries/32713-pivot-table-two-row-header.html)

sslack

Pivot Table with two row header?
 

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


--
sslack
------------------------------------------------------------------------
sslack's Profile: http://www.excelforum.com/member.php...o&userid=16442
View this thread: http://www.excelforum.com/showthread...hreadid=382621



All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com