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,019 thoughts on “Complex sorting

  1. kaspersky avg problem fix by sabbathfreakuku

    Excellent goods from you, man. I have understand your stuff previous to and you’re just extremely fantastic. I actually like what you’ve acquired here, certainly like what you’re stating and the way in which you say it. You make it entertaining and you still care for to keep it smart. I can not wait to read much more from you. This is really a great site.| а

  2. how to turn a friend into a girlfriend

    Its like you read my mind! You seem to know a lot about this, like you wrote the book in it or something. I think that you could do with a few pics to drive the message home a bit, but other than that, this is excellent blog. A great read. I will definitely be back.| а

  3. kroon casino bonus uitbetalen

    strategie jeu casino , lc speelautomaten arnhem – nederlandse casino online : casino777 mobiel .

Leave a Reply

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