Data Cleaning in Excel 101, Part 3: How to Combine Columns in Excel
Having the right data in the right columns to meet specific requirements for your analysis plays a major role in the data cleaning process. In Parts 2, 3, and 4 of our Data Cleaning in Excel series, we’ll show you how to solve common issues by utilizing both standard and Excel’s powerful “Flash Fill” shortcut.Part 2 focuses on splitting data from one cell to multiple cells. Here, in Part 3, we’ll cover the opposite: combining data from multiple columns into one column. Coming up in Part 4, we’ll showcase some incredibly useful and time-saving tricks with the mystical powers of Excel’s “Flash Fill” function.Combining Data from Multiple ColumnsIn our last blog post, we went over how to break apart data that has been exported into just one cell. What about...
Read More