How to make a selection of passengers in excel by parameter?

Question

excel

In column B there is a data check of TCD (adult), RB (child) or other data

It is necessary that adults and children are automatically copied into different columns, for example, adults in the "List of TCD", while their other data is copied, for example status
And the same with children.
Link to the file https://yadi.sk/i/nWf00qwiSl3-Pg

Answer 1

Array formula for column E (entered by pressing Ctrl+Shift+Enter).
File with prescribed formulas - here

Answer 2

Filter won't work? After filtering, you can do whatever you want with the data.