Array formula that captures data from multiple columns

[Puffycheek]

Hi all,

Is it possible to create an array formula in a column that captures data from multiple columns? It is important that an arrayformula is used because I am using an online form that captures data and spits it into a Google spreadsheet. Every time the form captures a new entry, the data is spit into a newly created column, thus a vlookup of any sort does not seem to work. Here's how the form responses would look:

Name	Food Category Media	Electronics Category Media	Ice Cream Category Media
John Doe	Home page banner
Harry Smith		Home page banner
Samuel Harrison			Home page banner

<tbody>
</tbody>

It is important to note that there will never be an answer in more than one of the three columns (Food Category Media, Electronics Category Media, Ice Cream Category Media). I'm looking for an array formula that captures the data from columns B,C,D and puts them into one column like displayed below:

Name	Media Booking
John Doe	Home page banner
Harry Smith	Home page banner
Samuel Harrison	Home page banner

<tbody>
</tbody>

Thanks for the help!

 

[Rick Rothstein]

If there will only be one value in Columns B, C, D for any given row, then you can simply concatenate the three cells (per row) together. For Row 2...

=B2&C2&D2