MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table table1 as
select 'в' as col1, 'q' as col2 union all
select 'ы', 'a' union all
select 'в', 'f' union all
select 'с', 'g' union all
select 'ф', 's'
create table table2 as
select '@' as col1, 'John' as col2 union all
select '£', 'Sara' union all
select '$', 'ciro' union all
select '%', 'Jo.'
select max(t1_col1), max(t1_col2), max(t2_col1), max(t2_col2)
from ((select t1.col1 as t1_col1, t1.col2 as t1_col2,
              null as t2_col1, null as t2_col2, row_number() over () as seqnum
       from table1 t1
      ) union all
      (select null, null, t2.col1, t2.col2, row_number() over () as seqnum
       from table2 t2
      ) 
     ) t
group by seqnum;


max(t1_col1)
max(t1_col2)
max(t2_col1)
max(t2_col2)


в
q
@
John

ы
a
£
Sara

в
f
$
ciro

с
g
%
Jo.

ф
s
null
null