software

I have three columns of data Date (mm/dd/yy), ID (unique and 45 of them)
and value. I want to re-arrange this data into an array, with ID across
as column headings, Dates on Column A, and values filling in wherever
Date and ID meet. The problem is not all dates have values for all the
ID's.

DateSensor IDValue
04/06/200510100.3546
04/06/200517200.27559
04/06/200524200.394
04/10/200556000.4334
04/10/200557000.394
04/10/200558000.394
04/10/200559000.3546
04/11/200510100.394
04/11/200517201.02362
04/11/200524200.788
04/11/200524401.0244
04/11/200524601.1032
04/11/200525001.0638

Rearrange as :

Date 1010 1070 2420 5600 .......
04/06/2005 0.35 0.28 0.39
04/10/2006
04/11/2006

I have a huge spreadsheet with about 6 months of data (6mo X 45 rows)
and have to arrange this in this manner.

Thanks.--
reachthepalace
------------------------------------------------------------------------
reachthepalace's Profile: www.excelforum.com/member.php...oamp;userid=31729
View this thread: www.excelforum.com/showthread...hreadid=518039