Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jun 9, 2016
Download Files: https://people.highline.edu/mgirvin/A... In this video learn about how to import multiple Excel files using Power Query (Get & Transform): 1. (00:15) Introduction 2. (01:32) Files used for Import 3. (02:46) Multiple Excel Workbooks with Multiple Sheets 4. (03:50) Get "City" names from Excel file names 5. (04:40) Use Power Query Function: Excel.Workbook([Content],true) to get Excel Data and Promote Headers in each excel File. 6. (06:06) Get "Sales Rep" names from Excel Worksheet names