Excel formula to get all values

Hi Gurus,

My head is really spinning on this one I can't seem to make it work! I have tried the lookup functions and none seemed to work. Please do help me! Its better if I can do it by formula, but if it can't, I'm very much open to macros too, just please help me in making this work!!

Scenario:
I have 2 worksheets.
Sheet1 : Raw Data (10,000 entries)
Sheet2 : Summary

In Sheet1 I have 2 columns
Column A is the Name of Room Column B is the amenities
I have 400 room names but for this example, let us just take 2, Sycamore and Pearl

Ex.
Column A                            Column B
Sycamore                            Radio
Sycamore                            TV
Sycamore                            Bathtub
Sycamore                            Dining
Pearl                               Bathtub
Pearl                               Smoking Area
Pearl                               Living Room

Now in Sheet2, I have to have this format:

     Column A                      Column B
1    Sycamore                      Pearl
2    Radio                         Bathtub 
3    TV                            Smoking Area 
4    Bathtub                       Living Room
5    Dining

Please help me on this!!
Thank you so much in advance!

Cheers,
Marie