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...
Yes this exactly what I need but on a larger scale. How do I use it?
How do I use it?
#1 Make sure you run Excel > 2013 on Windows
#2 Download the attached file
#3 Rename the columns in the blue Table (in sheet Input) as you want but column ID and add any additional columns you need
#4 Copy/paste your data in the blue Table
#5 Switch to sheet Output
#6 Right-click in the green Table > Refresh
- It gave me this error when I refreshed
[Expression.Error] An error occurred while accessing table Table1 because it contains overflow errors. Please fix the errors and try again.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
- If possible,upload your file which may be helpful for trouble shooting.
