Merging cells in Pivot tables

  • Thread starter Thread starter nidabland
  • Start date Start date
N

nidabland

We have made a pivot table with 15 columns. For the row that states
"companies from",we want to merge all 15 cells in that row so that the title
will merge and center. We tried selecting all the cells and doing a merge
and center but it says that we can't do that in a pivot table. Any help
please?
 
You can't merge those cells, though you could use another cell as a reference.

so, assuming your data is in B2:K2..

Merge B1:K1

Enter into B1:

=B2&" "&C2&" " etc...

and you can just hide row 2...
 
Back
Top