Forum Discussion
Merging data, but keep duplicates
I have an Excel sheet with student names and ID numbers 
another sheet with ID numbers and testing information, but no names
The sheet with testing information has a row of English and a row of Math for each ID number, so the ID numbers are duplicated. I need to create a sheet with the Student names, ID numbers, and testing information with 2 rows for each student.
The sheet with testing information has more students than I need - I have the set of students in the first sheet with the names and ID numbers, so I can't just copy and paste. The current process is to just go through the larger set and delete the rows of students we don't need (for ~400 of 500 students, no thanks). I was trying to follow this video - https://youtu.be/0uWjXuhvqB8 but I ended up with the same student IDs and test information for every student.
The easiest is with Power Query - query tables from first and second sheets, merge them and return the result into the third sheet. Simple sample is attached.
