Merging Datasets

I need to merge two columns of data by date. Merge into SEPARATE columns, not merge into ONE CELL. That is, 1 column has Jan 1 10 Jan 2 20 Jan 4 30 and the other column ha...

excel

Jamil
Mar 05, 2018
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.

Jamil

Bronze Contributor

Mar 05, 2018

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.

Willy Lau

Iron Contributor

Mar 06, 2018

Thanks Jamil, you have taught me a skill out of Excel. :)

Jamil
Bronze Contributor
Mar 06, 2018
You are welcome! :)

Forum Discussion

Merging Datasets

Resources