Excel Data Manipulation (Kinda like a Transpose)

I need to convert a dataset from columns to rows, kinda like transpose but a little different.

I need to change:

cars 1
cars 2
cars 3
book 5
book 6
book 7
cat 2
cat 3
cat 4

Into:

cars 1 2 3
book 5 6 7
cat 2 3 4


Anyone know how this can be done? Any help would be much appreciated

just how automatic do you need it to be?

the quickest solution i can think of, without resorting to vba, would be:
(assuming your data starts in cell E5)

for the category: =LEFT($E$5;FIND(" ";$E$5)-1)
for the number: =RIGHT(OFFSET($E$5;COLUMN(A1)-1;0))