Any Excel Gurus?
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?
|