Using Power Query to Combine Multiple Tables and Remove Duplicates | Everyday Office
Power Query can pull in data from multiple spreadsheets simultaneously, then append the contents into a single master table. When doing this, removing duplicates can create a unique list.
Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on:
http://www.knacktraining.com/blog/
http://www.knacktraining.com/podcast/
Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.