[FORMULA] Return String Value of Multiple Cells In One Cell

[xTwisteDx]

I have a batch of data in the following format.

This is my input:

GROUP	EMPLOYEE
someEmail1@here.com	Jane Doe
someOtherEmail@there.com	Johnny Lee
someOtherEmail@there.com	Jane Doe
someEmail1@here.com	Jacob Smith

<tbody>
</tbody>

My Expected Output would be:

Jane Doe	someEmail1@here.com someOtherEmail@there.com
Johnny Lee	someOtherEmail@there.com
Jacob Smith	someEmail1@here.com

<tbody>
</tbody>

Essentially I need a formula that will combine the values of the groups column but match it
on the names in the rows. Please note that the names are random, the emails are random, and there are repeating names.

 

[Eric W]

Perhaps:

	A	B	C	D	E	F
1	GROUP	EMPLOYEE		EMPLOYEE	Email
2	someEmail1@here.com	Jane Doe		Jane Doe	someEmail1@here.com	someOtherEmail@there.com
3	someOtherEmail@there.com	Johnny Lee		Johnny Lee	someOtherEmail@there.com
4	someOtherEmail@there.com	Jane Doe		Jacob Smith	someEmail1@here.com
5	someEmail1@here.com	Jacob Smith

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet11​

Worksheet Formulas Cell Formula D2 =IFERROR(INDEX($B$2:$B$10,AGGREGATE(15,6,(ROW($B$2:$B$10)-ROW($B$2)+1)/(($B$2:$B$10<>"")*(COUNTIF($D$1:$D1,$B$2:$B$10)=0)),1)),"") E2 =IFERROR(INDEX($A$2:$A$10,AGGREGATE(15,6,(ROW($B$2:$B$10)-ROW($B$2)+1)/(($B$2:$B$10=$D2)*(COUNTIF($D2:D2,$A$2:$A$10)=0)),1)),"")&"" <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Put the D2 formula in and drag down. Put the E2 formula in and drag down and across as needed.

 

[xTwisteDx]

Whenever I try that formula it only returns 3 names for the D2 column.

 

[xTwisteDx]

Whenever I try that formula it only returns 3 names for the D2 column.

Disregard, I forgot to update the cell references. I do however have one thing I need to figure out with your E2 formula. Instead of dragging it out, I need it to all be in the same cell and spaced by a new line within that cell. Thoughts?

 

[kweaver]

If you have Excel 365, you can use TEXTJOIN in the E column (from Eric's table) and flll down to only the unique values showing in column D.
It's an array formula, entered with CTRL+Shift+Enter

=TEXTJOIN(" ",TRUE,IF(D2=A2:A10,B2:B10,""))

You can make the space delimiter CHAR(10) and then wrap text if you want them on separate lines.