I have a datatable containing date in Column A, time in Column B, and value
in Column C. I want to translate (pivot) the table so that I have date in
row 1, time in row 2, and value at the intersect of date and time. How do I
do that???

e.g.
Date Time Value
06/01/2009 8:00 AM 20
06/01/2009 1:00 PM 60
06/01/2009 5:00 PM 65
06/02/2009 8:00 Am 40

Translate to
Date
Time 06/01/2009 06/02/2009
8:00 AM 20 40
1:00 PM 60
5:00 PM 40


Paul