Help with formula!!

Hello All,

I am trying to create a formula that will extrude text and number which are in two separate columns and report it in a different column! What I have done was made a sum formula that summed the length of different conduit sizes from a different table that the user inputs. The problem is with the columns I created. Since there's a lot of different conduit sizes there are a lot of cells that have a 0. What I have been having problems with is creating the formula that takes the text and numbers from the columns I created and inputs them combined in a different cell without having a large number of blank rows.

I have tried to use the filter option but whenever someone makes a small change to the conduit sizes they have to go to a different tab and refresh the filtered cells. I am trying to make it so that the user has to do nothing to these cells when changes are made!

I attached a quick snip of what I am currently dealing with. The column on the right of the highlighted columns is the part that I need the formula to bunch it together!

Thanks in advance,