This blog post was inspired by a recent dilemma. My wonderful VA – Zita Lewis – who helps ensure that all my course participants get what they need when they need it and quite frankly has much better attention to detail than I have 🙂 had got a list of course participants and she wanted to check for duplicates.
The names had been put on separate sheets for the different courses and while she could go through each of them and check or indeed use our old trusty friend “Ye Olde Copy And Paste” – I thought it would be fun (yes, I have strange ideas of fun…) to show you how you could do this in Power Query… You can download the starting file here and you can download the completed file here.