Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating using array formula?? | Excel Discussion (Misc queries) | |||
Transpose words and numbers into array of different proportions | Excel Discussion (Misc queries) | |||
Conditional Formatting for Array containing Text | Excel Worksheet Functions | |||
Transpose and order array numbers | Excel Worksheet Functions | |||
Transpose into a _working_ transposed array | Excel Discussion (Misc queries) |