Sheet1 has employee name in column 1 and assigned seat in column 2.
A B
John Doe Seat 1
Jane Doe Seat 1
Alex Raymon Seat 2
Aaron Smith Seat 2
Hillary Reese Seat 3
Mary Lamb Seat 3

I now want to do Sheet2 that references Sheet1.
A B C
Seat 1 Seat 2 Seat 3
John Doe Alex Raymon Hillary Reese
Jane Doe Aaron Smith Mary Lamb

So formula would be if Sheet1!Column B = Seat 1, put the employee's name in
row 2, then put the next employee's name in row 3 and so on.

Hopefully this isn't too confusing. Any help would be appreciated. Thanks
in advance.