Merge And Center Only Column Labels Of A Pivot Table

[KrisSquare]

Hello

I have attached the file with data and sample pivots

If you see in the file I have 2 pivots for same Data

Pivot1 ---> Labels are merged and centered in both Rows ( Segment1, segment2, etc) and columns (01-Sep-2013, 01-Nov-2013 etc).

Pivot2 ----> All labels in rows and columns are repeated.

Requirement is that I want to create a single pivot with columns Labels as in Pivot1 (Merged) and row labels as in the Pivot2 (repeated).

Thanks
Kris