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:

[TABLE="class: grid, width: 700"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Food Category Media[/TD]
[TD]Electronics Category Media[/TD]
[TD]Ice Cream Category Media[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]Home page banner[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Harry Smith[/TD]
[TD][/TD]
[TD]Home page banner[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Samuel Harrison[/TD]
[TD][/TD]
[TD][/TD]
[TD]Home page banner[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Media Booking[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]Home page banner[/TD]
[/TR]
[TR]
[TD]Harry Smith[/TD]
[TD]Home page banner[/TD]
[/TR]
[TR]
[TD]Samuel Harrison[/TD]
[TD]Home page banner[/TD]
[/TR]
</tbody>[/TABLE]

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