Conditional transpose to Array
 

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.

Date Sensor ID Value
04/06/2005 1010 0.3546
04/06/2005 1720 0.27559
04/06/2005 2420 0.394
04/10/2005 5600 0.4334
04/10/2005 5700 0.394
04/10/2005 5800 0.394
04/10/2005 5900 0.3546
04/11/2005 1010 0.394
04/11/2005 1720 1.02362
04/11/2005 2420 0.788
04/11/2005 2440 1.0244
04/11/2005 2460 1.1032
04/11/2005 2500 1.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: http://www.excelforum.com/member.php...o&userid=31729
View this thread: http://www.excelforum.com/showthread...hreadid=518039