I have previous blogged on how to unpivot data using Excel  and Excel 365 (was Excel 2016) just keeps getting better and better. It can now do ETL (Extract, Transform and Load) operations that used to require SSIS.

This article tell you how to import multiple CSV files in one operation. (for example, bank statements).