Adding multiple colors to text in multiple cells

[ETNA91]

Hello,

I'm looking for some help on adding text color to a column of text but with a unique twist to it. Below is a screen shot of the data i'm working with. The first row is how I want all the rows to look like when complete. I used the formula Concatenate to combine the columns together but, of course, excel formulas do not combine formatting of the cells used in the formula. Is there a way to copy the formatting of cell P2 for the rest of the cells in column P? I hope that explains what I'm trying to do, if not please ask so I can clarify my question.

 

[ETNA91]

This is a link to the photo I wanted to insert in the original post that didn't work. Sorry about that.
https://goo.gl/photos/YVwaXVVaSMP8CEeS6

 

[mikerickson]

The link says that your Album Is Empty.

 

[ETNA91]

Lets try this one more time....
https://goo.gl/photos/NbSAJu6msVeCzZ5c7