Merge Rows Help (Not Concatenate)

[roos289]

Hello,

First time posting so be gentle!

I'm trying to merge values that look like the attached sheet in rows 1-4.

Into 1 row with all of the values for that company like the example in rows 6-7

Everywhere I looked has me buying add-ins to help.

Thank you!