Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have a script that collects data from a list of servers. I would like to accomplish two different things in Excel with this data. Here is a sample of the data: CNTXDC01,C:\winnt\$NtUninstallKB925902$,kb925902,0 5/04/2007 05:38:18,28 CNTXDC01,C:\winnt\$NtUninstallKB930178$,kb930178,0 5/04/2007 05:38:25,28 CNTXDC02,C:\winnt\$NtUninstallKB931836$,kb931836,0 5/30/2007 00:29:12,2 CNTXDC02,C:\winnt\$NtUninstallKB932168$,kb932168,0 5/30/2007 00:28:50,2 CNTXQA01,C:\winnt\$NtUninstallKB824151$,kb824151,1 1/11/2004 16:35:23,932 CNTXQA01,C:\winnt\$NtUninstallKB825119$,kb825119,1 1/11/2004 16:36:07,932 CNTXQA01,C:\winnt\$NtUninstallKB826232$,kb826232,1 1/11/2004 16:38:40,932 CNTXSQL01,C:\winnt\$NtUninstallKB828749$,kb828749, 12/05/2004 10:46:41,908 CNTXSQL01,C:\winnt\$NtUninstallKB896424$,kb896424, 04/28/2006 01:04:48,399 CNTXSQL01,C:\winnt\$NtUninstallKB914388$,kb914388, 08/10/2006 22:37:37,295 First, I would like to sort each group of data by date (Column 4). Each group is seperated by a blank line and should stay that way. Second, and somewhate tougher I think, is I want to insert a new worksheet and down Column A I would like to have each UNIQUE item from Column 3 and accross the top in ROW 1 I would like to have each UNIQUE item from Column A in the original worksheet. Like this: CNTXDC01 CNTXDC02 CNTXQA01 ... kb925902 kb930178 kb828749 kb896424 .... And then with that matrix, place the date where it lines up with the server name column and the hotfix row. Can anyone tackle this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Gurus-Please Help! | Excel Discussion (Misc queries) | |||
OK, a really tricky one now for Excel gurus! | Excel Discussion (Misc queries) | |||
Excel VBA Gurus needed | Excel Discussion (Misc queries) | |||
Looking for Excel VBA gurus | Excel Programming | |||
For the Excel Query Gurus | Excel Worksheet Functions |