Across the spreadsheet,
E2=A2 + " " + $B$1
F2=A2 + " " + $C$1
G2=A2 + " " + $D$1

copy down to last row

Assuming data are in A2 to G1000
Rearrange data to read B2, E2
B3, E3
B4, E4 ....
B1000, E1000
C2, F2
C3, F3 ....
C1000, F1000
D2, G2 ....
D1000, G1000

now sort by date.

Close enough?

Cheers

"Robert Judge" wrote in message
...
I have an EXCEL 2003 worksheet with four columns and about one thousand
rows
containg this sample data:
NAME BIRTHDATE ANNIVERSARY DEATH DATE
John Smith June 1, 1920 July 15, 1940 August 1, 1980
Mary Jones January 1, 1930 September 15, 1955 October 1, 1995

I would like to create a worksheet that would sort all of the information
by
date. For instance, the worksheet would display the above data in one
column
like this:
June 1, 1920 John Smith Birthdate
January 1, 1930 Mary Jones Birthdate
July 15, 1940 John Smith Anniversary
September 15, 1955 Mary Jones Anniversary
August 1, 1980 John Smith Death Date
October 1, 1995 Mary Jones Death Date

This may be impossible, of course, but I thought I would ask just in case
anyone has an idea. I will appreciate advice.