If you work with any type of data, then you know that rarely does it come perfectly in the format you need. Power Query (also called Get & Transform in Excel 2016) is the solution to this problem.
Power Query is an amazing ETL tool (Extract, Transform, and Load). If you're not using it then you're missing out on the best new feature in Excel.
This article shows you, via an example, how to import and clean complex and messy data using Power Query.