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

Lorenzo The thing is, the file contains sensitive information which I am not allowed to share. 
If it is not possible to this without sharing, then I'll just have to do it manually, but thanks for trying.

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