Looking at Example B of your link, I would accomplish this either using MS Access and joining the two tables on the common ID. If you don't have Access, then you can do the same with MS Query, which is included as part of your Excel package. You will need to use SQL to make it happen. Look at this link.

Use MS Query to Treat Excel as a Relational Data Source