Modify VBA in Excel Macro to concat

I need modifications made to the VBA code in an existing Excel macro. The current output generates multiple lines of formatted data. The task is to adjust the macro so that this output is concatenated into single lines for each sent of data, with each new line of data separated by a single space. The end result should maintain the existing formatting of the data while ensuring it is presented in the specified single-line format.
* See Example JPG for sample data *