Can I merge two sheets based on a single column?

%3CLINGO-SUB%20id%3D%22lingo-sub-3415351%22%20slang%3D%22en-US%22%3ECan%20I%20merge%20two%20sheets%20based%20on%20a%20single%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3415351%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20two%20sheets.%20One%20contains%202018-2022%20registration%20data%2C%20and%20one%20contains%20manual%20audit%20data%20for%20a%20series%20of%20courses.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20cover%20almost%20all%20the%20same%20courses%20but%20without%20100%25%20overlap.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20both%20contain%20a%20column%20%22CourseID%22%20that%20can%20be%20used%20for%20keying%20a%20merge.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20merge%20the%20two%20sheets%20automatically%2Fbetter%20than%20by%20hand%3F%20Basically%20add%20the%202018-2022%20registration%20data%20columns%20to%20the%20manual%20audit%20sheet%20intelligently%2C%20and%20add%20rows%20for%20any%20courses%20in%20the%202018%20sheet%20that%20aren't%20in%20the%20manual%20audit%20sheet.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20contains%20500%20rows%2C%20which%20isn't%20that%20crazy%2C%20but%20I'll%20be%20doing%20this%20a%20bunch%20in%20the%20future%20so%20I%20wanted%20to%20see%20if%20there's%20a%20better%20way%20before%20I%20do%20it%2020%20times%20by%20hand%20this%20year.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3415351%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3416884%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20merge%20two%20sheets%20based%20on%20a%20single%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3416884%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1398582%22%20target%3D%22_blank%22%3E%40Leo084250428%3C%2FA%3E%26nbsp%3BI'd%20recommend%20Power%20Query!%20Fairly%20easy%20to%20merge%20your%20files%2C%20especially%20since%20you%20have%20the%20CourseID's%20in%20both.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello!

 

I have two sheets. One contains 2018-2022 registration data, and one contains manual audit data for a series of courses.

 

They cover almost all the same courses but without 100% overlap.

 

They both contain a column "CourseID" that can be used for keying a merge.

 

Is there a way to merge the two sheets automatically/better than by hand? Basically add the 2018-2022 registration data columns to the manual audit sheet intelligently, and add rows for any courses in the 2018 sheet that aren't in the manual audit sheet. 

 

It contains 500 rows, which isn't that crazy, but I'll be doing this a bunch in the future so I wanted to see if there's a better way before I do it 20 times by hand this year.

1 Reply

@Leo084250428 I'd recommend Power Query! Fairly easy to merge your files, especially since you have the CourseID's in both.