Basic column and row tools
In this section, you will work with many column tools in order to remove columns you no longer require and split columns so that data is separated from one column into separate columns. You will be working the extract, merge, index, and conditional columns.
You will learn how to reshape table data so that the data is cleaned and ready for analysis in other applications, such as Power BI and Excel Power Pivot, by removing unwanted columns; removing top or bottom rows, should there be additional information you don't require; using the index column to aid analysis; creating conditional columns based on criteria you provide and applying column filtering using AND/OR conditions; using the single and multiple criteria filter; removing any duplicating rows or null values; working with the header row in a query; and splitting column values into separate delimiters. These options help to shape data so that it is presented in a format that aids reporting.
...