In this lecture we’ll cover the necessary steps and transformations to combine data from various Excel files in a folder that are not in Excel tables.