Concatenate cells on same row ignoring blank cells

Hi,

Trying to concatenate multiple cells on same row and separating value of each cell with a semicolon ( in between but not if previous column cell(s) is(are) blank.

I have attached a sample file to make it clear.

Happy New Year!
RJ

PS
I do have a separate issue which I'll post later, if this formula does not give me clues how to solve the other problem.

Thank you Trevor. Happy New Year.

Originally Posted by HansDouwe

Meanwhile, TEXTJOIN should be available in EXCEL 2019.

If that's correct, please try:

Formula:

=TEXTJOIN(";",,IF(H2<>"",H2&"-"&MIN(1,Q2),""),CT2:CW2)

Hans, thank you so much for your very quick response.

Your formula worked except the MIN function will always returns 1 no matter what is in column Q
=TEXTJOIN(";",,IF(H2<>"",H2&"-"&MIN(1,Q2),""),CT2:CW2)

I modified it to this and it works as needed.
=TEXTJOIN(";",,IF(H2<>"",H2&"-"&Q2,"1"),CT2:CW2)

Happy New Year.