Rearranging data with VBA

Hi everyone,

I have some data like this in the SOURCE sheet:

ASGN	CRANE	MSG	TIME
19069621	11	ARQ	14:35:41
19069621	11	ACP	14:36:32
19069621	11	ARQ	14:36:32
19069621	11	ACP	14:37:17

I would like to turn the data into the following form in the DESTINATION sheet.
The important thing is that the time stamps are dealt with in the correct chronological order.

ASGN	CRANE	ARQ1	ACP1	ARQ2	ACP2
19069621	11	14:35:41	14:36:32	14:36:32	14:37:17

Please see the attached file for some example data.
140424_ForumDemo.xlsx

I will be very grateful for any help with this.

Best regards,
Knut

Here is without VBA:

I saw now there are some duplicated ASGN's with different CRANE.
Try this:

Hi zbor, and thanks for your suggestion!

Your kind of wild formulas seems to work well in the file you provided, but when copying the formulas to my main document, I get a #NUM! error for all cells past the range I gave in the example.

Attached is the complete main file.
140424_ForumDemo2.xlsx

Confirm formula (except column B) with ctrl+shift+enter (not just enter)
A curely brackets {} must appear around your formula (but those brackets can not be entered manually)

That solves everything! Thank you so much!

Where can I find some reference to what ctrl+shift+enter does?

It's called Array Formula. Try to google for that term. Something like this