Excel Formatting Question

Giganews Newsgroups
Subject: Excel Formatting Question
Posted by:  CoxTech1 (HRD-HSI.newsgrou…@cox.com)
Date: Tue, 22 Jul 2008

Hopefully somebody will know the answer to this.  I have a SQL query in
an Excel spreadsheet that returns the following data:

jimjones    6/25/2008 7:58:35    6/25/2008 19:12
jimjones    6/27/2008 8:50:25    6/27/2008 20:00
jimjones    6/28/2008 8:47:48    6/28/2008 14:54
jimjones    6/28/2008 14:57:57    6/28/2008 20:02
jimjones    7/1/2008 8:40:45    7/1/2008 20:16
jimjones    7/2/2008 7:51:33    7/2/2008 13:06
jimjones    7/2/2008 13:06:32    7/2/2008 19:00
jimjones    7/4/2008 8:48:48    7/4/2008 20:01
bobsmith    6/25/2008 12:59:50    6/25/2008 14:13
bobsmith    6/25/2008 14:13:43    6/25/2008 14:30
bobsmith    6/25/2008 14:30:54    6/25/2008 17:01
bobsmith    6/25/2008 17:01:36    6/25/2008 17:14
bobsmith    6/25/2008 17:14:25    6/25/2008 17:27
bobsmith    6/25/2008 17:27:05    6/25/2008 18:14
bobsmith    6/25/2008 18:14:29    6/25/2008 18:18
bobsmith    6/25/2008 18:18:59    6/25/2008 19:52
bobsmith    6/25/2008 19:52:17    6/25/2008 20:15
bobsmith    6/25/2008 20:15:53    6/25/2008 20:21
bobsmith    6/25/2008 20:21:17    6/25/2008 21:27

I would like to know if there is a way to automate the sheet in such a
way that the output looks more like this:

jimjones    6/25/2008 7:58:35    6/25/2008 19:12
    6/27/2008 8:50:25    6/27/2008 20:00
    6/28/2008 8:47:48    6/28/2008 14:54
    6/28/2008 14:57:57    6/28/2008 20:02
    7/1/2008 8:40:45    7/1/2008 20:16
    7/2/2008 7:51:33    7/2/2008 13:06
    7/2/2008 13:06:32    7/2/2008 19:00
    7/4/2008 8:48:48    7/4/2008 20:01
bobsmith    6/25/2008 12:59:50    6/25/2008 14:13
    6/25/2008 14:13:43    6/25/2008 14:30
    6/25/2008 14:30:54    6/25/2008 17:01
    6/25/2008 17:01:36    6/25/2008 17:14
    6/25/2008 17:14:25    6/25/2008 17:27
    6/25/2008 17:27:05    6/25/2008 18:14
    6/25/2008 18:14:29    6/25/2008 18:18
    6/25/2008 18:18:59    6/25/2008 19:52
    6/25/2008 19:52:17    6/25/2008 20:15
    6/25/2008 20:15:53    6/25/2008 20:21
    6/25/2008 20:21:17    6/25/2008 21:27

Any help would be greatly appreciated.

Replies