Forum Discussion
Merging Datasets
Hello Keith,
WOW! what a good question.
I can write VBA code that does the job; however, I prefer using Power Query (Get & Transform) for doing this, because it will be dynamic and when you add or remove data, upon just a refresh the data will update.
I have just recorded a video based on your example data set on how you can get the needed result using Power Query. Power Query is built-in Feature in Excel 2016 and 365 and 2013 as Add-in and 2010 to be installed as separate add-in.
Please watch the animated gif. if you have any question, let me know.
you can view the animated gif in large mode, if you click into the image.
Hello Keith,
WOW! what a good question.
I can write VBA code that does the job; however, I prefer using Power Query (Get & Transform) for doing this, because it will be dynamic and when you add or remove data, upon just a refresh the data will update.
I have just recorded a video based on your example data set on how you can get the needed result using Power Query. Power Query is built-in Feature in Excel 2016 and 365 and 2013 as Add-in and 2010 to be installed as separate add-in.
Please watch the animated gif. if you have any question, let me know.
you can view the animated gif in large mode, if you click into the image.
thank you for posting that video.
I will try to use it. LOL, the video is SO fast though, I'm not sure I can even see what you are doing in the video.
Keith,
Thanks for feedback :)
I have uploaded a video version here, so that you can watch it at your pace.
Jamil,
Thanks a lot. The video was very clear and explanatory. I've tried this technique on my data, and it worked.
Keith
- You are welcome! :)
