Hi,
Apologies if already answered I can't figure out how or if this can be done a bit easier than I already am doing. I have found some vb code but the code I have I would need to do each column. So my problem is I need to delete duplicates in a table but keep the rows, to explain/show better below are screenshots of what I mean -
The table I have -
1.png
And I need it to look like below -
2.png
As you can see I need to keep rows in column D that are all unique values whilst deleting/clearing the adjacent cells and keeping the top row of each unique row of data, if that makes sense.
Thanks.
Bookmarks