ExcelBanter - Pivot Tables - merged cell problems

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Tables - merged cell problems (https://www.excelbanter.com/excel-discussion-misc-queries/198692-pivot-tables-merged-cell-problems.html)

Sherry

Pivot Tables - merged cell problems

I have a spreadsheet in which some of the columns headers are merged
therefore preventing me to complete the wizard. Is there a work-around?

Tom Hutchins

Pivot Tables - merged cell problems

Un-merge the column headers and give each column its own heading.

Hope this helps,

Hutch

"Sherry" wrote:

I have a spreadsheet in which some of the columns headers are merged
therefore preventing me to complete the wizard. Is there a work-around?

All times are GMT +1. The time now is 05:44 AM.