I need a formula that will concatenate B+C+D+E+F+G+H+I+J. You will see that not all the values in each column are the same length, if they are not I need to add spaces to the end so that the next string of characters when combined, starts at the specific location for that column.

in rows 18,19, and 20 I have manually entered what I require the formula to return for the 3 examples I provided. the red characters correspond with the first character index ( 0=first character, 9=eleventh, T=twenty forth, 4=forty second, A=fifty forth, and so on)

I have set up data validation for the cells, what I need help with is a concatenate formula that will include the necessary amount of spaces following the value if it doesn't exceed the allowed length.