Help manipulating external data??

Giganews Newsgroups
Subject: Help manipulating external data??
Posted by:  Jock
Date: Tue, 29 Jul 2008

In work I pull through a list of data externally using Microsoft Query and a
thing called relativity. It pulls through a list of job numbers and for each
job number there is a timestamp and an event for each time. Basically the
info looks like this

Job Number        Time            Event

31555                13:10              1
31555                13:15              3
31555                13:25              11
31666                18:10              5
31666                18:30              6
31666                18:33              12
31667                21:22              1
31667                21:26              11

However, I want to turn the information round in Excel so that it runs left
to right for each status, so for example

Job Number            Event 1          Event 3          Event 11
31555                      13:10              13:15            13:25

Does anyone know of a way to do this. I can't do it at source or through
Query, so it has to be done within Excel?

Thanks for any help in advance

Replies