Chapter 2: Transform Data with Data Tools

In this chapter, we will cover how to use some of the data tools provided in Excel 2019 to quickly perform data organizing tasks.

In this chapter we will cover how to:

• Find and remove duplicate rows in your data.
• Find and delete blank rows in your data.
• Convert text to columns.
• Consolidate data from different worksheets into one worksheet.