Excel Help - Merge on a common key

Copper Contributor

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

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