use Excel Power Query Editor to help you combining & expanding 2 tables into 1