Excel Help - Merge on a common key

%3CLINGO-SUB%20id%3D%22lingo-sub-1559334%22%20slang%3D%22en-US%22%3EExcel%20Help%20-%20Merge%20on%20a%20common%20key%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1559334%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Community%2C%3C%2FP%3E%3CP%3EI'm%20about%20to%20start%20a%20project%20and%20potentially%20need%20to%20complete%20data%20merge%20on%20a%20common%20key%20in%20Excel.%26nbsp%3B%20What%20might%20be%20the%20most%20efficient%20approach%20to%20doing%20this%2C%20assuming%20large%20data%3F%26nbsp%3B%20I've%20seen%20some%20posts%20involving%20Power%20Query%2C%20which%20I%20am%20not%20familiar%20with.%26nbsp%3B%20Any%20assistance%20would%20be%20much%20appreciated-%20TY!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1560129%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%20-%20Merge%20on%20a%20common%20key%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1560129%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20and%20good%20morning%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746277%22%20target%3D%22_blank%22%3E%40AnmarieO%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20searched%20for%20power%20query%20in%20Microsoft%20learn%20and%20it%20comes%20up%20with%20close%20to%20600%20results...%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsearch%2F%3Fcategory%3DLearn%26amp%3Bterms%3Dpower%2520query%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsearch%2F%3Fcategory%3DLearn%26amp%3Bterms%3Dpower%2520query%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20this%20is%20rather%20unspecific%20maybe%20a%20starting%20point%20like%20this%20is%20useful%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Flearn%2Fpaths%2Fpower-plat-fundamentals%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Flearn%2Fpaths%2Fpower-plat-fundamentals%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20us%20know%20once%20you%20started%20your%20journey%20and%20I%20hope%20it%20helps.%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3CBR%20%2F%3ERolf%3CBR%20%2F%3E%3CBR%20%2F%3E%23MCT%20%23LearnWithRolf%20%23TheCloud42%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hey Community,

I'm about to start a project and potentially need to complete data merge on a common key in Excel.  What might be the most efficient approach to doing this, assuming large data?  I've seen some posts involving Power Query, which I am not familiar with.  Any assistance would be much appreciated- TY!!

1 Reply
Highlighted

Hello and good morning @AnmarieO

I searched for power query in Microsoft learn and it comes up with close to 600 results...

https://docs.microsoft.com/en-us/search/?category=Learn&terms=power%20query

 

Since this is rather unspecific maybe a starting point like this is useful:

https://docs.microsoft.com/en-us/learn/paths/power-plat-fundamentals/

 

Let us know once you started your journey and I hope it helps. 

Cheers
Rolf
#MCT #LearnWithRolf #TheCloud42