Merge And Center Only Column Labels Of A Pivot Table

[KrisSquare]

Hello All

When I use "Merge & Center cells with Labels" of a pivot table, It is merging Column labels as well as row labels. Is there a workaround to apply this feature only for column labels and not for row labels.

Please advice

Thanks
Kris

I already posted this in MrExcel.com and below is the link


http://www.mrexcel.com/forum/excel-questions/756475-merge-center-only-column-labels-pivot.html

[Excel Fox]

Can you post a sample trimmed down version of the pivot, recreating the issue.

[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