How to display many results vertically

I have been working on a spreadsheet where there are many results to a formula and I want to display them all vertically. I have been using a formula that was been working for me until now.

I am working on the first sheet Languages in column G the formula searches the name(cell F5), language spoken (cell F2) and level of spoken language (cell F3) and I want it to display the column headers (senior languages info, Cells E2:H2). Am I using the formula correctly? or Maybe my data in the senior languages info sheet is too confusing?

Firstly, before I talk about the formula, if I am understanding this correctly, the "Level" spoken in column G, is basically whatever the level is selected in F3. That is, if it's 1, the Levels will ALL be "1. Few words". If it's 2 then it will all be "2. Technically Fluent". So why have this column?

With regards to the formula, if my logic above is right, the last ROWS function is not required - replace it with a 1 and the formula will work.

G5:

Formula:

BEFORE: =IFERROR(INDEX(LOOKUP(COLUMN('senior languages info'!$E$2:$H$2),COLUMN('senior languages info'!$E$2:$H$2)/('senior languages info'!$E$2:$H$2<>""),'senior languages info'!$E$2:$H$2),SMALL(IF(INDEX('senior languages info'!$E$3:$H$94,MATCH(1,('senior languages info'!$A$3:$A$94=Languages!$F5)*('senior languages info'!$D$3:$D$94=Languages!$F$2),0),0)=Languages!$F$3,COLUMN('senior languages info'!$E$2:$H$2)-COLUMN('senior languages info'!$E$2)+1),ROWS(Languages!G$5:G5))),"")

AFTER : =IFERROR(INDEX(LOOKUP(COLUMN('senior languages info'!$E$2:$H$2),COLUMN('senior languages info'!$E$2:$H$2)/('senior languages info'!$E$2:$H$2<>""),'senior languages info'!$E$2:$H$2),SMALL(IF(INDEX('senior languages info'!$E$3:$H$94,MATCH(1,('senior languages info'!$A$3:$A$94=Languages!$F5)*('senior languages info'!$D$3:$D$94=Languages!$F$2),0),0)=Languages!$F$3,COLUMN('senior languages info'!$E$2:$H$2)-COLUMN('senior languages info'!$E$2)+1),1)),"")

Thanks for that. Eventually the formula in column F will be

=IFERROR(INDEX('senior languages info'!A$3:A$93,SMALL(IF(('senior languages info'!$D$3:$D$93=Languages!$F$2)*('senior languages info'!$E$3:$H$93>=Languages!$F$3),ROW('senior languages info'!$A$3:$A$93)-2),ROWS(E$5:E5))),"") so the results will include levels from 4 and below so we would like to know which people have level 4 and level 3 and so on.