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.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

ntb Author

Level 1

11 points

Combining Tables in Numbers

How can two Tables be combined to produce a new single table with the same data, formulae and conditional highlighting without having to add rows individually and enter the data manually?

The intention is to combine several large tables with up to 100 rows in each to produce a single consolidated table. (please see attached doc).

I'm sure there's a simple way to do this but it's not immediately obvious (to me!) Thanks for your help.

macOS Ventura 13.4.1

Numbers v13.1

Mac Studio 2022

Posted on Jul 2, 2023 11:37 PM

Top-ranking reply

Yellowbox

Level 7

20,957 points

Posted on Jul 3, 2023 12:35 AM

Hi ntb,

Click on the "Bullseye" (top left) of Table 1 to select the whole of Table 1.

Menu > Edit > Duplicate Selection (command D).

That will duplicate Table 1 and rename the copy as table 1-1

Drag Table 1-1 by the "Bullseye" to a convenient (temporary) place on the "canvas" (Numbers sheet).

Click on any cell in the last row of Table 1-1 and press return to create a blank row (Row 5 in this example).

Row 5 of Table 1-1 is now ready to receive data pasted from another table.

Select data from Table 2 (rows 2 and down) and copy.

Click in cell A5 of table 1-1 and Paste

Rename Table 1-1 as table 3

Regards,

Ian.

View in context

Combining Tables in Numbers

Similar questions