Hi,

I have been asked to prepare a report from a log file (.xls) that
reports 34 User activities. The current time and date values are
formatted like this...

LineNo User Activity Value
2 DoeJ sessionSTART at 10:46:14
3 DoeJ sessionDATE 09-07-2004
38 DoeJ sessionENDtime 10:51:44
40 DoeJ sessionSTART at 10:56:07
41 DoeJ sessionDATE 09-07-2004
76 DoeJ sessionENDtime 10:56:24
77

... but I would like to report them like this ...


LineNo User Activity Value
2 DoeJ sessionStart at 09-07-2004 10:46:14
38 DoeJ sessionEnd at 09-07-2004 10:51:44
40 DoeJ sessionStart at 09-07-2004 10:56:07
76 DoeJ sessionEnd at 09-07-2004 10:56:24
Any help you can offer would be appreciated.

- Henry