I posed this question recently, but wasn't able to get an answer. I don't think I described the issue very well at all, so I thought I'd try again as I think I have a simpler way to explain.
I have worksheets with data for two Olympic games (Rio in 2016 and London in 2012). Each worksheet has the events as columns and the participating countries as rows. As both the events and the participating countries vary from one Olympics to the next the column and row headings will be similar but not identical.
The cells in each workbook contains the number of medals won by each country in each event.
The ask is to merge the data into a 3rd worksheet showing the medal count for each country/event at both Olympics. For example Canada won 1 medal for swimming in London and 3 medals in Rio. The 3rd worksheet should have a medal count of 4 for Canada/Swimming
Bookmarks