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. healthy fresh recipes

    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.

  2. Ephedrine online bestellen

    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!

  3. 출장

    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.

  4. App Vlc Player 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.

  5. Adipex kaufen

    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!

  6. Agen Poker Terpercaya

    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.|

Comments are closed.