I am working on a large document that has a couple hundred columns of data. Many of these rows have duplicate values in the columns that I need to remove.
Here is a sample sheet:
What I need is to be able to go through each row, find the duplicates in columns B:E and delete all but one of the cells, preferably shifting the rest of the cells left to avoid blank cells. I would need to keep all rows and the rest of their data intact.
So, given the above example, the result would look like this:
A couple notes:
- The cells in question all appear at the end of each row
- Reasoning: All these values were stored as a list in a single column and split out using
Text to Columns. I now need to clean it up and remove the duplicates.
- There are thousands of rows and a couple hundred of extra columns that may have duplicates.
Is this possible, even with VBA? Any suggestions are greatly appreciated. Thank you!