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”

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

Comments Closed.