Need help with Textjoin or concat function

[Modnar1]

So I have a row of fields and most will contain a number that to me has a value assigned to it. The value is not important and will be manipulated elsewhere. What I need is a summary of those values (essentially creating a code that acts as a roadmap. So I may enter a number in 5 fields but leave 3 empty because they do not apply, but still need it to fill into the overall "summary" value for the empty field.

Code 1	Code 2	Code 4	Code 5	Code 6	Code 7	Size	Code 8	Code 9	Code Summary
1						2XL			1.2XL	I need every field accounted for
1						3XL			1......3XL..	This doesn’t work either
1						3XL			1.0.0.0.0.0.3XL.0.0	This is what I need it to come out like
1						Small

[#2 · Accepted solution]

@Modnar1 

=TEXTJOIN(".",,IF(ISBLANK(A2:I2),TEXT(A2:I2,"0"),A2:I2))

You can try this formula which returns the intended result in my sheet.

[#3]

Thanks that works, I knew that some easy way existed...