Formula needed to reorganise data

Hi all,

I'm really hoping someone can help. I need to change data that is in this form...

ID Fruit Qty
1468 Apples 3
1468 Kiwi 1
1468 Strawberry 6
1468 Orange 1
1468 Mango 8
1543 Apples 3
1543 Kiwi 4
1543 Orange 7
1408 Apples 2
1408 Kiwi 7
1408 Strawberry 12
1408 Mango 8
1408 Orange 15

Into data in this form...

ID Apples Kiwi Strawberry Orange Mango
1468 3 1 6 1 8
1543 3 4 7
1408 2 7 12 15 8

I've been working on it without luck for quite a few hours now, and was hoping someone could point me in the right direction.

Thanks

Is this what you want? Pivot table?

Yes, that looks like it!

Thank you very much