Power Query Combine Files from Folder

Learn the easiest way to combine multiple Excel files into one Workbook. With Power Query you can import files directly from a folder and append them into one table or Pivot Table. It just takes a few clicks.