Complex sorting

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

1,207 thoughts on “Complex sorting

  1. App Para Samsung Smart Tv Iptv

    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.

  2. Aplicativo Maxor Tv

    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.

  3. casino sbobet

    I have been surfing online more than three hours today, yet I never found any interesting article like yours. It is pretty worth enough for me. In my opinion, if all webmasters and bloggers made good content as you did, the internet will be much more useful than ever before.|

  4. bandar sbobet

    You could certainly see your skills in the article you write. The arena hopes for more passionate writers like you who aren’t afraid to mention how they believe. At all times go after your heart.|

  5. Huruf Timbul

    I have in order to voice my passion with regard to your kindness giving assistance to those people of which must have guidance on this particular important matter.

  6. tali lanyard

    Prevailing without the answers in order to the difficulties you’ve categorized out through this guidebook is a critical circumstance, as well as the particular kind which could include badly affected my complete career if I acquired not discovered your internet site.

  7. sbobets

    Hi there very nice blog!! Guy .. Excellent .. Superb .. I’ll bookmark your web site and take the feeds also? I’m satisfied to find so many useful info here in the post, we’d like work out more techniques in this regard, thanks for sharing. . . . . .|

  8. Cythia Coyco

    whoah this blog is excellent i love reading your posts. Keep up the good work! You know, a lot of people are searching around for this info, you can aid them greatly.

  9. 출장안마

    I will right away grab your rss feed as I can at find your email subscription hyperlink or newsletter service. Do you have any? Please allow me know so that I could subscribe. Thanks.

  10. idn poker

    Hello, all the time i used to check web site posts here early in the break of day, since i enjoy to gain knowledge of more and more.|

  11. brilliantlighttherapy

    You actually make it seem so easy with your presentation but I find this topic to be really something which I think I would never understand. It seems too complicated and extremely broad for me. I am looking forward for your next post, I will try to get the hang of it!

  12. anabole steroide kaufen Deutschland

    The other day, while I was at work, my sister stole my iPad and tested to see if it can survive a thirty foot drop, just so she can be a youtube sensation. My apple ipad is now broken and she has 83 views. I know this is totally off topic but I had to share it with someone!

  13. peptide zum verkauf

    I haven’t checked in here for a while since I thought it was getting boring, but the last several posts are good quality so I guess I will add you back to my daily bloglist. You deserve it my friend 🙂

  14. peptides

    We are a group of volunteers and opening a new scheme in our community. Your website provided us with valuable information to work on. You have done an impressive job and our entire community will be thankful to you.

  15. situs bokep

    I am really inspired with your writing talents and also with the format for your blog. Is this a paid subject matter or did you customize it yourself? Either way stay up the nice quality writing, it’s uncommon to peer a nice weblog like this one today..|

  16. Acquistare Phentermine HCL in linea

    Thanks for sharing superb informations. Your web-site is very cool. I am impressed by the details that you have on this web site. It reveals how nicely you perceive this subject. Bookmarked this web page, will come back for more articles. You, my pal, ROCK! I found just the info I already searched all over the place and just couldn’t come across. What an ideal website.

  17. Buy Melanotan 2 UK

    We are a gaggle of volunteers and starting a brand new scheme in our community. Your website offered us with helpful info to work on. You have performed an impressive task and our entire group will likely be grateful to you.

  18. Buy Melanotan 2 online UK

    I’m extremely impressed with your writing skills and also with the layout on your blog. Is this a paid theme or did you customize it yourself? Anyway keep up the nice quality writing, it is rare to see a great blog like this one nowadays..

  19. 9mobile data plans

    You have made some really good points there. I checked on the net to learn more about the issue and found most people will go along with your views on this web site.|

  20. Fake

    I’m amazed, I must say. Rarely do I encounter a blog that’s both equally educative and amusing, and let me tell you, you have hit the nail on the head. The problem is something not enough folks are speaking intelligently about. I’m very happy that I came across this in my search for something concerning this.|

  21. Miami Movers

    I know this if off topic but I’m looking into starting my own blog and was wondering what all is required to get setup? I’m assuming having a blog like yours would cost a pretty penny? I’m not very internet smart so I’m not 100 sure. Any recommendations or advice would be greatly appreciated. Thanks|

  22. produksicetak

    Simply wish to be able to say your article is usually as astonishing. The quality in your post is merely great, and I may assume you are the expert on this subject matter. Well with your authorization allow me to grab your RSS OR ATOM feed to help keep updated using forthcoming post. Thanks the million and please continue to keep up the gratifying do the job.

Comments are closed.