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