Sort data based on date

Hi

I have a lot of data that I need to sort depending on the date.

I have daily observations for ten years on stock prices for 5 different stocks. The problem is that since the stocks are traded in different countires, the dates doesn't always match because of the different holydays etc. This means that some 95% of the dates are identical, but some are different. Because of this, the values for the stocks on ex. date 2 aren't in the same row.

The data I have is like this (the letter values continues, just didn't bother to put them in )

__Obs 1_________Obs 2__________Obs 3 .........................................
Date__Value...... Date__Value.....Date___Value
1...........a.............2.........b............1..........a
2...........b.............3.........c............2..........b
4...........d.............4.........d............4..........d
5..........................5.......................6
6..........................7.......................7
8...................................................8

What I need is a way to sort the date so it looks something like this so it is possible to compare the date based on the dates. (the value a,b,c,... shouldn't be sorted and are not alike, it is just to illustrate.)


...Obs 1.................Obs 2................Obs 3
Date__Value......Date__Value.......Date__Value
1...........a......................................1..........a
2...........b.............2.........c............2..........b
4...........d.............4.........d............4..........d
5...........e.............5.........e..........................
6...................................................6...........
............................7........g.............7..........g
8...........h......................................8..........h

I hope it makes sence and that someone has a great solution

Thank you in advance!

Kind regards
Thomas

Hi viuf81

Sorting and/or Filtering on Dates is squirrelly at best. You'll be best served if you post an example workbook that demonstrates what you have and what you'd like it to be. Perhaps one of us can help.