This tutorial shows a powerful and helpful feature in Excel Power Query. Here's the url that I used in the video demo to link up the data set. https://www.exchangerates.org.uk/USD-GBP-exchange-rate-history.html
This video will go over how to use the Merge feature in Power Query. You will learn how to do the following: Left Outer JoinRight Outer JoinInner JoinLeft Anti JoinRight Anti JoinFull Outer Join
This video will show you how to create a Power Query reports from your source data. It will separate the file types based on using a delimeter.