Matching Rows and appending field at the end

[Hastings]

Please see the example.
I want to take all the matching rows and add the employee name in the 5th column to the end of the row.

Project #	Type	Task	Description	Assigned To
HCC939	NA	Design	Create Design for customer	Bob Smith
HCC939	NA	Design	Create Design for customer	Frank Jones
HCC939	NA	Design	Create Design for customer	Tom French
HCC939	NA	Dev	Point of Sale Credit Card system creation	Ted Brown
HCC939	NA	Dev	Point of Sale Credit Card system creation	Ed Black
Project #	Type	Task	Description	Assigned To	Assigned To	Assigned To	Assigned To
HCC939	NA	Design	Create Design for customer	Bob Smith	Frank Jones	Tom French
HCC939	NA	Dev	Point of Sale Credit Card system creation	Ted Brown	Ed Black
since rows 2,3,4 are the same in columns A-B-C-D I want to produce a row like row 9 with the names appened to the end.

 

[Cubist]

One option.

Book1
	A	B	C	D	E	F	G
1	Project #	Type	Task	Description	Assigned To
2	HCC939	NA	Design	Create Design for customer	Bob Smith
3	HCC939	NA	Design	Create Design for customer	Frank Jones
4	HCC939	NA	Design	Create Design for customer	Tom French
5	HCC939	NA	Dev	Point of Sale Credit Card system creation	Ted Brown
6	HCC939	NA	Dev	Point of Sale Credit Card system creation	Ed Black
7
8
9	HCC939	NA	Design	Create Design for customer	Bob Smith	Frank Jones	Tom French
10	HCC939	NA	Dev	Point of Sale Credit Card system creation	Ted Brown	Ed Black
Sheet1

Cell Formulas
Range	Formula
A9:D10	A9	=UNIQUE(A2:D6)
E9:G9,E10:F10	E9	=TOROW(FILTER($E$2:$E$6,BYROW(--(A9:D9=$A$2:$D$6),LAMBDA(r,SUM(r)))=4))
Dynamic array formulas.

 

[KOKOSEK]

If You've got XL365 lets use some its functions:

Book1
	A	B	C	D	E	F	G	H
1	Project #	Type	Task	Description	Assigned To
2	HCC939	NA	Design	Create Design for customer	Bob Smith
3	HCC939	NA	Design	Create Design for customer	Frank Jones
4	HCC939	NA	Design	Create Design for customer	Tom French
5	HCC939	NA	Dev	Point of Sale Credit Card system creation	Ted Brown
6	HCC939	NA	Dev	Point of Sale Credit Card system creation	Ed Black
7
8
9	Project #	Type	Task	Description	Assigned To	Assigned To	Assigned To	Assigned To
10	HCC939	NA	Design	Create Design for customer	Bob Smith	Frank Jones	Tom French
11	HCC939	NA	Dev	Point of Sale Credit Card system creation	Ted Brown	Ed Black
12
Sheet1

Cell Formulas
Range	Formula
A10:D11	A10	=LET(a,$A$2:$D$6,UNIQUE(a))
E10:G10,E11:F11	E10	=TRANSPOSE(FILTER($E$2:$E$6,($A$2:$A$6=$A10)*($D$2:$D$6=$D10)))
Dynamic array formulas.

 

[Hastings]

This worked great it did repeat the last colum on a few not sure why.