Pivot Table

[Harshi]

Hi All,

I am working on pivot table where my table looks like below.

	22-Jan			22-Feb
Dimension	Measure 1	Measure 2	Measure 3	Measure 1	Measure 2	Measure 3
A
B
C
D

My Required Output format is 

22-Jan

22-Jan

22-Jan

22-Feb

22-Feb

22-Feb

Dimension

Measure 1

Measure 1

Measure 2

Measure 2

Measure 3

Measure 3

Measure 1

Measure 1

Measure 2

Measure 2

Measure 3

Measure 3

A

B

C

D

Wanted to know how Can I do this in Pivot table.

[G3S]

are you looking to duplicate your measures?
if so, only thing is top row will  not show 22Jan for each measure, it will be across all six(3 measures duplicated  (how it is across the three in the first table in your post)