You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

How to merge cells in a Pivot Table in Numbers?

(EXAMPLE CELL A4, A5 AND A6 ALL TOGETHER)

Posted on Nov 2, 2024 8:48 PM

Reply
1 reply

Nov 2, 2024 9:29 PM in response to Targaret

Generally merging cells in Numbers is not a great idea. You can easily achieve the same visual effect without merging.


You definitely don't want to try merging cells in a Pivot Table.


If you need special formatting select the cells in the Pivot Table, command-c to copy, click once in a cell of a "regular" receiving table that you have already set up, and paste. Then edit and format in that table.


You can concatenate values in cells with the & operator (in a formula it would be something like =A4&A5&A6). Or you can use the concatenate function.


CONCATENATE - Apple Support


SG


How to merge cells in a Pivot Table in Numbers?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.