Hi,
I have an excel sheet, that - post data-cleaning - has multiple rows. For example:
A B C D E F Ohio 1020 Paul Ohio 1020 Paul New York 1110 Virginia Ohio 1020 Paul Ohio 1020 Paul
Which Should ideally look like
A B C D E F Ohio 1020 Paul New York 1110 Virginia
All those entries for Ohio are duplicates, and I want only one row for Ohio. I have simplified the excel to understand the approach I must take - actual excel sheet has around 15/20 columns for now.
Ideally this would be a function/procedure that I can call from multiple subroutines (at the end of data-cleaning). Tried searching for online examples and other posts in the forum, after my attempts at this fell flat on my face (I even successfully managed to delete *all* rows in the sheet, without any recovery possible, after the cleaning subroutine took 45 mins to run. Brilliant.
Attaching a sample work sheet to illustrate. Is this even possible? Thanks..
Bookmarks