User Profile
3zafandi
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Merging duplicate entries without loosing data
So I have an excel file with over 4000 entries. Each entry has an ID on the fourth column "D", and base on this column there are many entries with the same ID (aka duplicates). Each copy of duplicates may have columns with the same data and columns with different data (ex: some are empty cells in one copy, but filled in another copy). So my objective is to merge each duplicated row (based on ID) without losing any data. I don't want to just delete the duplicates and for example keep the first copy of each set, because the second or third copy may have data or columns not filled in the first copy. Also if it is the same exact data (ex: lets say in column labeled "degree" both copy 1 and 2 have data "Bachelor") only write it once, otherwise merge them with a comma or semicolon in between. Is this at all possible to do without having to manually go through each entry? Thanks50KViews0likes10Comments
Recent Blog Articles
No content to show