C
CoxTech1
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.
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.