Páčilo by sa Ti viac napr toto: ?

do bunky S3 (a do ostatných skopírovať):

=SUBSTITUTE(TRIM(INDEX(B1:B2;(B3=L$1)+1;) & " " & INDEX(C1:C2;(C3=L$1)+1;) & " " & INDEX(D1:D2;(D3=L$1)+1;) & " " & INDEX(E1:E2;(E3=L$1)+1;) & " " & INDEX(F1:F2;(F3=L$1)+1;) & " " & INDEX(G1:G2;(G3=L$1)+1;) & " " & INDEX(H1:H2;(H3=L$1)+1;) & " " & INDEX(I1:I2;(I3=L$1)+1;) & " " & INDEX(J1:J2;(J3=L$1)+1;));" ";", ")

v českej verzii:

=DOSADIT(PROČISTIT(INDEX(B1:B2;(B3=L$1)+1;) & " " & INDEX(C1:C2;(C3=L$1)+1;) & " " & INDEX(D1:D2;(D3=L$1)+1;) & " " & INDEX(E1:E2;(E3=L$1)+1;) & " " & INDEX(F1:F2;(F3=L$1)+1;) & " " & INDEX(G1:G2;(G3=L$1)+1;) & " " & INDEX(H1:H2;(H3=L$1)+1;) & " " & INDEX(I1:I2;(I3=L$1)+1;) & " " & INDEX(J1:J2;(J3=L$1)+1;));" ";", ")