The Best NEW Functions for Data Transformation in Excel

Learn how to clean messy Excel data and professionally reshape it using the new WRAPROWS and WRAPCOLS functions.

In this tutorial, I walk through a complete Excel data cleaning workflow, starting with common workbook problems such as unwanted images, hyperlinks, inconsistent formatting, data labels, blank rows, and messy columns. Then, we finish by reorganizing the cleaned data with WRAPROWS and WRAPCOLS.

These newer Excel functions make it much easier to turn long, unstructured lists into clean rows or columns without manually copying, pasting, or rearranging data.

In this Excel tutorial, you will learn how to:

• Remove all images, shapes, icons, and other objects from an Excel worksheet
• Remove hyperlinks from Excel cells
• Normalize inconsistent Excel formatting
• Remove data labels and other unwanted worksheet elements
• Quickly delete empty rows in Excel
• Clean and adjust entire columns at once
• Transpose data from rows to columns
• Use WRAPROWS to split a list into organized rows
• Use WRAPCOLS to split a list into organized columns
• Build a cleaner and more professional Excel data cleaning workflow

This tutorial is useful for anyone working with imported reports, exported system data, copied website data, downloaded CSV files, or spreadsheets that need to be cleaned before analysis.

If you'd like to learn more about automating Excel, check our Excel Automation Courses.

I hope you enjoy the video! :)

Don