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

Try this, copy the data, then in a black area with plenty of room
right-click, choose Paste Special, check the Transpose box and hit ok, that
should give you what you want.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"jock" wrote:

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

Looking closer, that probably won't do it, you will need some code to get
that the way i think you want it, one line per job number.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"jock" wrote:

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

If each job number/event combination has exactly one time, you could use a
pivottable.

in xl2003 menus:
Select the range
A1:C###
Data|Pivottable
Follow the wizard until you get to a step with a Layout Button on it.
Click that layout button
Drag the header for the Job Number field to the Row column
Drag the header for the event field to the column area
drag the header for the time field to the data area
If it doesn't say "Sum of", then rightclick on that button and choose Sum.

Then finish up the wizard.

You'll have to select the range with the times and format them to show times.
I'd use a custom format of:
[hh]:mm



jock wrote:

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

--

Dave Peterson