help me with this, plz?

Question

I have three data sets in excel format:

1- Column 1 = set of dates from 1-Jan-1980 to 31-Dec-2006.

2-Column 2 = set of non-continuous dates, e.g. 3-Jan-1980, 6-Feb-1980, 23-Apr-1981, etc. these dates are a subset of column (1) set.

3-Column 3 = set of variables each corresponding to a value in Column (2) set of dates.

What i want to do is to arrange column (3) with respect to Column (1) set. In other words, to expand column (2) and (3) to match column (1).

What software can do this? (to match the contents of columns in one step).

Answer 1

no need for other software, just use the "filter" which is a feature in ms excel