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