combine multiple rows into one row based on unique id

Hi - I need to convert a large spreadsheet with multiple rows for each unique-id into one row .

Not sure if I need a macro but hoping someone can help.

My data is currently in this format:

ID Date of Order Order
ORDER001 28/06/2005 APPLES
ORDER001 11/07/2005 ORANGES
ORDER001 15/07/2005 PEARS
ORDER001 12/02/2016 BANANAS

and I need it to look like this:

ID Date of Order 1 Order 1 Date of Order 2 Order 2 Date of Order 3 Order 3 Date of Order 4 Order 4
ORDER001 28/06/2005 APPLES 11/07/2005 ORANGES 15/07/2005 PEARS 12/02/2016 BANANAS

many thanks - any help really appreciated!

Thanks so much - will give it a try!