ExcelBanter - Formula to List Results?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula to List Results? (https://www.excelbanter.com/excel-worksheet-functions/155047-formula-list-results.html)

Jen1170

Formula to List Results?

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

All times are GMT +1. The time now is 06:39 AM.