Compare and merge cells

Hi rmzn74,

There are many ways to handle this problem, below is a solution via formula. 

=TRANSPOSE(FILTER($B$2:$B$4,$D2=$A$2:$A$4))

Note: If your version of the office doesn't support the FILTER function, then feel free to use Excel Online, these functions are available free to use  (https://office.live.com/start/excel.aspx)

Regards, Faraz Shaikh | MVP, MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget to mark it as the Official/Best Answer & like it to help the other members find it more.