Forum Discussion
Leo084250428
May 23, 2022Copper Contributor
Can I merge two sheets based on a single column?
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...
Riny_van_Eekelen
May 23, 2022Platinum Contributor
Leo084250428 I'd recommend Power Query! Fairly easy to merge your files, especially since you have the CourseID's in both.