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...
You probably have an option with Power Query - see attached sample that shouldn't be far from what you expect assuming I understood it all
- 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.
