searching in a list and transposing it into another list

[vivavo]

I am trying to create a formula to do the following. On sheet 1, I have a huge data table. One of the columns contains a "Group" drop down list where someone will specify A, B, or C. In the next column, it will specify a name. These are all unique values.

Name	Group
Bob	A
Jenny	B
Vicky	B
Joe	C
Kelly	A
Anne	C

On a seperate sheet I need to list out who is all in which group dynamically (if the first sheet changes, which it will frequently, I need the next tab to update). The groups are across the top, and the Names need to list down. For example, the result would be:

A	B	C
Bob	Jenny	Anne
Kelly	Vicky

I don't know how many names are going to be in each group, and they won't be listed one after the other. I tried variations of VLOOKUPs and MATCHES but nothing gets me the list I need.

[protonLeah]

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[jindon]

Where did Joe go?

[icestationzbra]

a formulaic approach:

[vivavo]

I would like to be able to do this with a formula, but when I recreate your formula in my spreadsheet, it's not working. It's most likely becuase I don't understand the formula and am missing something. Can you walk me through what each piece is doing?