Forum Discussion
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...
No way to identify what causes the issue with an error message only. Please attach your file to your next reply. If you can't attach a file upload & share it with any file sharing service (OneDrive, Google Drive...) and post the shared link
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.
- 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.