Summary  
This chapter covers how to pivot tabular data by transforming rows into columns, aggregating values, and cleaning inconsistencies via replace-value and table-reference transformations.

General domain of usage  
Business intelligence reporting

Let's dive into creating pivoted data in Power BI using the **Matrix visual** and **Power Query**. The Matrix visual allows you to easily drag and drop fields into Rows, Columns, and Values areas to create interactive **pivot tables**. For more advanced manipulation, Power Query lets you pivot columns directly in your dataset by transforming rows into columns based on your chosen fields.

What is the main purpose of using the **Matrix visual** in Power BI?

Pivoting Data