I have the following data in one worksheet:

abc red 1
abc blue 2
abc green 3
edf red 3
edf orange 5
edf purple 4

I need a formula to do the following sort in new worksheet:

abc red 1 abc blue 2 abc green 3
edf red 3 edf orange 5 edf purple 4

When I use the Vlookup formula, it only searches the first top results, but
I need it to search the next on at the bottom, until there isn't any abc or
edf left.