I have 2 excel files that I want to merge. Each has 2 columns, one of which is dates and one of which is dollar amounts. Within each sheet, the dates are in order, but are basically random, meaning that some dates are skipped and some have more than one entry.
I want a resulting merged sheet to have all the dates in order, but to keep the dollar amounts in separate columns.
For example:
Sheet 1
June 3, 2008 146.56
June 3, 2008 256.47
June 7, 2008 585.29
June 11, 2008 127.27
Sheet 2
June 3, 2008 426.90
June 8, 2008 155.53
June 10, 2008 22.79
June 12, 2008 187.99
Resulting sheet
June 3, 2008 146.56
June 3, 2008 256.47
June 3, 2008 426.90
June 7, 2008 585.29
June 8, 2008 155.53
June 10, 2008 22.79
June 11, 2008 127.27
June 12, 2008 187.99
Admittedly, a strange request, but I have good reason for whanting to do it this way.
By: David
I was very happy to uncover this great site. I wanted to thank you for your time just for this fantastic read!! I definitely loved every part of it and I have you saved as a favorite to check out new information on your blog.
You actually make it appear really easy together with your presentation however I find this topic to be actually something which I think I might by no means understand. It sort of feels too complicated and very large for me. I am having a look ahead in your next submit, I’ll try to get the cling of it!
keep up the superb piece of work, I read few articles on this web site and I think that your blog is rattling interesting and has got bands of fantastic information.
Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.
It’s perfect time to make a few plans for the long run and it is time to be happy. I have learn this publish and if I could I desire to recommend you few fascinating things or advice. Maybe you can write subsequent articles referring to this article. I wish to learn even more issues about it!
Thanks for every other wonderful post. The place else could anyone get that type of info in such a perfect method of writing? I’ve a presentation next week, and I’m at the search for such information.|
Hello there, I found your website by way of Google at the same time as searching for a comparable matter, your site got here up, it looks great. I’ve bookmarked it in my google bookmarks. а