How to combine lines from two tables in EXCEL?

Question

excel

Please help me combine lines from AJ12:AO62 and AP12:AU62 tables and insert their lines into AV12:BA62
File https://yadi.sk/i/n-WMHhqOf_XVXw
There is a formula, but it only combines columns from a given range
Array formula :
=IFERROR(IF(COUNT($W$11:W11)<=COUNTIF($S$12:$S$62,"?*");INDEX(S:S,MINIMUM(IF($S$12:$S$62< >"";ROW($S$12:$S$62));ROW(1:1)));INDEX(U:U;SMALL(IF($U$12:$U$62<>"";ROW($ U$12:$U$62));ROW(1:1)-COUNTIF($S$12:$S$62;"?*"))));"")

Two tables should be merged into one without empty lines

I did such a formula in cell AV12

=ЕСЛИОШИБКА(ЕСЛИ(СЧЁТЗ($AV$11:AV11)<=СЧЁТЕСЛИ($AJ$12:$AJ$62;"?*");ИНДЕКС(AJ:AJ;НАИМЕНЬШИЙ(ЕСЛИ($AJ$12:$AJ$62<>"";СТРОКА($AJ$12:$AJ$62));СТРОКА(1:1)));ИНДЕКС(AP:AP;НАИМЕНЬШИЙ(ЕСЛИ($AP$12:$AP$62<>"";СТРОКА($AP$12:$AP$62));СТРОКА(1:1)-СЧЁТЕСЛИ($AJ$12:$AJ$62;"?*"))));"")

Enter ctrl+shift+enter
But part of the data disappears (highlighted by a red cloud)
File with this formula https://yadi.sk/i/wKvrbIsARehJCA

Answer 1

The formula is almost correct. You need to remove the column freeze here:
=IFERROR(IF(COUNT( $ AV$11:AV11)
That is, it should be:
=IFERROR(IF(COUNT(AV$11:AV11)
The file with the corrected formula is here