PivotTable from Many CSV Files
Download File: https://www.excel-university.com/yt_h...
In this video, we'll summarize data from multiple CSV files with a PivotTable. Specifically, we'll use a Get & Transform query (Power Query) to retrieve and prepare data from numerous CSV files. Then, we'll send the query results into the data model (Power Pivot). Then, we'll build our summary report using a PivotTable based on the data model. And, it will be easy! And fun :)