Retrieve multiple values for a repeated value in a column

[EverLearner00]

If I had this sheet:
| A | B |
|------+--------|
| 1 | Apple |
| 2 | Banana |
| 2 | Mango |
| 3 | Grape |
| 4 | Peach |

How do I list unique values from the first column followed by corresponding values in the adjacent columns. So, I get a table like this:
| D | E | F |
|-------|-------|-------|
| 1 |Apple| -----|
| 2 |Banana | Mango |
| 3 |Grape| ----|
| 4 |Peach| -----|

of course my data is much larger, and this is just for illustration

 

[DRSteele]

Welcome to the Forum.

This might help. No doubt there is a better way that spills the result with a single-cell formula, but this will get the job done.

MrExcel posts20.xlsx
	A	B	C	D	E	F
1	1	Apple		1	Apple
2	2	Banana		2	Banana	Mango
3	2	Mango		3	Grape
4	3	Grape		4	Peach
5	4	Peach
Sheet22

Cell Formulas
Range	Formula
D1:D4	D1	=UNIQUE(A1:A5)
E1,E3:E4,E2:F2	E1	=TRANSPOSE(FILTER(B1:B5,A1:A5=D1))
Dynamic array formulas.