Transforming Data

In this lesson, you will learn transformations in Power Query that enable you to unpivot and re-pivot to structure your data to a database format.

In this lesson, you will learn about manipulating rows of data using Power Query.

In this lesson, you will learn how to manipulate data in Power Query by removing, splitting, extracting, duplicating and merging columns. You will also learn the other skills such as manipulation of numeric data, using conditional columns and index columns.

In this lesson, you will master the skills required to change the structure of the data using Power Query transformations, such as transpose, reorder columns, remove columns and change the row order of the data.

In this lesson, you will learn how to create a column from example.