In the previous two chapters, you saw how to hone your dataset in Power Query so that you defined only the rows and columns of data that you really need as the basis for your analysis. Then you learned how to cleanse and complete the data that they contain. In this chapter, you will learn how to build on these foundations to deliver data that is ready to be molded into a structured and usable data model.
The generic term for this kind of data preparation in Power Query is restructuring data. It covers the following:
Joining queries: This involves taking two queries and linking ...
