Repetitive columns to simple horizontal table

[normanlang]

Hi experts

I have hit a snag! How can I convert this:

Name Boxes Number
Bec apples 1
Bec oranges 2
Bec pears 3
Bec bananas 4
Bec moo deng 5
Bec sapparot 6
David apples 7
David oranges 8
David pears 9
David bananas 10
David moo deng 11
David sapparot 12
Bec2 apples 13
Bec2 oranges 14
Bec2 pears 15
Bec2 bananas 16
Bec2 moo deng 17
Bec2 sapparot 18
David2 apples 19
David2 oranges 20
David2 pears 21
David2 bananas 22
David2 moo deng 23
David2 sapparot 24


to this:

app oran pea bana moo sapparot
Bec 1 2 3 4 5 6
David 7 8 9 10 11 12
Bec2 13 14 15 16 17 18
David219 20 21 22 23 24

[zbor]

Here, try this

[:) Sixthsense :)]

Or

Use pivot table, refer the attached file for details

[normanlang]

Here, try this

This is brilliant! I am truly impressed. Thank you so much for your expertise.

[normanlang]

Or

Use pivot table, refer the attached file for details

Thanks Sixthsense, it makes a lot of sense.

[zbor]

Of course, PT is better option