Learn Excel - Clean Data with Power Query - Podcast 2037

Two Power Query tricks today: Importing a list of files from a folder into Excel and then cleaning all CSV files in a folder. Episode Recap:
The Power Query tools are on the Data tab in Excel 2016
Free add-in for 2010 and 2013
List all files from a folder into the Excel grid using Power Query
Choose New Query, From File, From Folder
Not obvious: expand the attribute field to get size
If your data is in CSV files, you can import all of the files at once into a single grid
Promote the heading row
Delete the remaining header rows
Replace "" with null
Fill down for the outline view
Delete the grand total column
Unpivot the data
Formula to convert month names into dates
Complete list of steps - world's greatest Undo
Next day - refresh the query to re-do all of the steps

Видео Learn Excel - Clean Data with Power Query - Podcast 2037 канала MrExcel.com