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

42 thoughts on “Complex sorting

  1. suba suba

    NiyaPT This is a really good tip particularly to those new to the blogosphere. Brief but very accurate info Thanks for sharing this one. A must read post!

  2. balenciaga shoes

    When I initially commented I clicked the -Notify me when new comments are added- checkbox and now each time a remark is added I get 4 emails with the identical comment. Is there any way you can remove me from that service? Thanks!

  3. Chia se cach

    Thank you a bunch for sharing this with all people you really recognize what you are talking about! Bookmarked. Kindly also consult with my site =). We can have a hyperlink trade agreement between us!

  4. foreign songs

    Im no expert, but I think you just made a very good point point. You certainly comprehend what youre talking about, and I can actually get behind that. Thanks for being so upfront and so genuine.

Leave a Reply

Your email address will not be published. Required fields are marked *