Combine files from Folder - Part One

Part one of a two part series on how to use Power Query to combine the contents of a folder and extract a pivot table from it.