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...
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.