I have several tables each with an unequal number of values in. I want to merge the values in these tables into one single overall table. I need to consider compatibility, so please don't give a formulaic solution that involves dynamic arrays. Preferably a non-array solution that uses the INDEX and AGGREGATE functions if possible.
Please see my example workbook to get a clear idea what I'm trying to achieve.
Bookmarks