Formula to List Results?

J

Jen1170

Brent Julie Eric 69 PB Mod Ag
Brent Julie Eric 70 International
Brent Julie Eric 72 Emerging
Brent Julie Jill 253 S & P 500
Brent Julie Jill 109 VP Mid Cap
Assuming that the top left corner is cell A1, what formula would I use to
get results that will look like this:

Eric
PB Moderate Ag
International
Emerging

Jill
S & P 500
VP Mid Cap
 
Top