declare @s varchar(100) = '20200101;234;Adress;1212;data1;23;data2;44;el;23';

with s(rn, v) as
(
 select
  row_number() over (order by c.n),
  c.n.value('.', 'varchar(100)')
from
 (select cast(cast('' as xml).query('sql:variable("@s")') as varchar(max))) a(s) cross apply
 (select cast('<item>' + replace(a.s, ';', '</item><item>') + '</item>' as xml)) b(x) cross apply
 b.x.nodes('item') c(n)
)
select
 s1.v, s2.v
from
 s s1 join
 s s2 on s2.rn = s1.rn + 1
where
 s1.v in ('data1', 'data2');