Chapter 4: Reshaping Your Data
When data grows in size and complexity, you need tools that allow you to make sense of your data and create views that can be relevant for reporting and presenting that data. In order to do this, they need features and options to reshape their data properly and to clean it if needed, especially when you can't edit data sources directly. Often, they connect to data that does not have a correct schema or a correct column name and they need to group and change how data is displayed.
In the recipes in this chapter, you will see how to leverage Power Query's built-in features that will allow you to reshape your data, to change its structure, and to adapt it to your reporting needs.
In this chapter, we will cover the following recipes:
- Formatting data types
- Using first rows as headers
- Grouping data
- Unpivoting and pivoting columns
- Filling empty rows
- Splitting columns
- Extracting data
- Parsing JSON or XML ...
