I have data in a column that I want to consolidate. To get an Idea of what I'm talking about, it's exactly the scenario at this help page: http://support.microsoft.com/kb/213367
I want to take the data (in my case, names) that appear in both columns and compile them so they don't have blank cells between them. If you take a look at that page, there are blank cells between data points.
The solution I have come up with is to copy that data to a separate column as values only and then Sort A-Z to cut out the blanks. Does anyone know of a more automated way to do this - perhaps one that wouldn't require a good amount of experience with Excel to operate?
I want to take the data (in my case, names) that appear in both columns and compile them so they don't have blank cells between them. If you take a look at that page, there are blank cells between data points.
The solution I have come up with is to copy that data to a separate column as values only and then Sort A-Z to cut out the blanks. Does anyone know of a more automated way to do this - perhaps one that wouldn't require a good amount of experience with Excel to operate?