Combining three company codes into one reporting code

[LStevenson]

I am a  fairly new user and have been assigned with converting all of our depreciation calculations into Alteryx workflows. I have completed much of it but I am struggling to combine 3 of my row items into a single line for ease of reporting I have tried several methods, including formulas, and replace, but have not been successful. I am attaching a copy of what I have coming out of  my Summerize tool, and what I need my final version to look like. I am attaching a simplified version below. Thanks for your help!

[Qiu · Accepted solution]

@LStevenson 
Hope this is what you need.

[LStevenson]

Thanks so much. This worked great. It is something I will need to do on a regular basis so I am going to attempt to turn it into a macro, also. I really appreciate your help and your quick response.

[Qiu]

@LStevenson 
Glad to help and thank you for the accept mark as well.