Hoping for some help regarding a complex Vlookup Funcion ....

here is a piece of the data table

Order Number Unit Ordered
570 Apple
570 Peach
570 Pear
571 Peach
571 Plum
572 Pear


Basically, what I want to do is type in 570 in one cell and then have Apple appear in Row 1, Peach appear in row 2 and Pear appear in Row 3 of a new worksheet....

How can this be done?