Forum Discussion
Merging duplicate entries without loosing data
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
[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
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.
- If possible,upload your file which may be helpful for trouble shooting.
