Excel IF formula pulling text cell from multiple blank cells

I'm trying to use a formula that will take the cell in a row that contains text from multiple other blank cells.

Row 1: Blank, Blank, Apple
Row 2: Blank, Orange, Blank
Row 3: Blank, Blank, Blank

I need the resulting column to fill: Apple, Orange, "blank"