Forum Discussion

3zafandi's avatar
3zafandi
Copper Contributor
May 31, 2023

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 duplicate...
excel
Formulas and Functions
3zafandi's avatar
3zafandi
Copper Contributor
Jun 04, 2023
Update: I tried the file again with only the first 1000 rows and it worked but there were some missing data. I noticed 2-3 columns completely empty for some reason.
Lorenzo's avatar
Lorenzo
Silver Contributor
Jun 04, 2023

3zafandi 

I noticed 2-3 columns completely empty for some reason Many reasons can lead to this

I do understand the sensitivity of the data. On the other hand anonymizing (i.e. Names) shouldn't take too much time

Up to you...

Resources