Merging cells in Pivot tables

[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?

 

[Sean Timmons]

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...