MacMost Q&A Forum • View All Forum QuestionsAsk a Question

Merging Two Tables, Using One Column As Primary Key

I need to Merge following two tables in ‘Numbers’.

Table 1
ID . Name . Gender
1| . A| . M
2| . B| . M
3| C| . F
4| . D|. F
Table 2

ID . Class . Status
1| . Boxing| . Scheduled
1| . Dance|. Completed
2| . HIIT|. Completed
2| . MMM|. Completed
2| . Aerobics|. Missed
3| . Boxing|. Missed

The resultant Table should be

ID . Name . Gender . Class . Status

1| . A . M . Boxing Scheduled
1| . A . M . Dance . Completed
2| . B . M . HIIT . Completed
2| . B . M . MMM . Completed
2| . B . M . Aerobics . Missed
3| . C . F . Boxing . Missed
4| . D . F . — —

Thanks
—–
SM

Comments: One Response to “Merging Two Tables, Using One Column As Primary Key”

    3 months ago

    Do you really want to merge the tables? Or do you want something more dynamic, where you can add to the table and have the values looked up and filled in as needed?

    Check out https://macmost.com/a-simple-numbers-lookup-example.html and see if this is what you are looking for.

    Even if it is not, you can use this and then copy the resulting cells, then paste the value over those same cells to get a permanent merge.

Leave a New Comment Related to "Merging Two Tables, Using One Column As Primary Key"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)