Consolidating text onto one row based on a given year

[Manexcel]

I have 3 columns of data - around 50 rows.

Col A is a date (Promotion year)
Col B is last name
Col C is rank (this is the same for all)

Data example

2017 bloggs manager
2017 smith manager
2016 adams manager
2015 bloggs manager
2014 smith manager
2014 adams manager
etc

Can a formula consolidate those rows that have a common year be consolidated onto one row (separate cells) for example:

ColA ColB ColC ColD ColE

2017 bloggs smith mans
2016 adams
2015 bloggs
2014 smith adams jones mans

etc

Is there a formula that can achieve this?

Many thanks for your consideration.

 

[wideboydixon]

Book1
	A	B	C	D	E	F	G	H	I
1	2017	bloggs	manager		2017	bloggs	smith
2	2017	smith	manager		2016	adams
3	2016	adams	manager		2015	bloggs
4	2015	bloggs	manager		2014	smith	adams	jones	mans
5	2014	smith	manager
6	2014	adams	manager
7	2014	jones	manager
8	2014	mans	manager
Sheet1

Cell Formulas
Range	Formula
F1	{=IFERROR(INDEX($B$1:$B$50,SMALL(IF($A$1:$A$50=$E1,ROW($A$1:$A$50)-ROW($A$1)+1),COLUMNS($F1:F1))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

Copy F1 formula across and down as necessary.

WBD

 

[Manexcel]

Many thanks for all your help. Your solution worked just great! This thread can now be closed.