Merge Multiple Columns Into Single

[oguruma1218]

I have a dataset that consts of several columns Street(A), City (B), Bedrooms(C), Bathrooms (D), etc.

I need to merge this into a single column (X). I think the best way to do this would be to write an expression that will bring all of that data into its own column.

The result would in the column would be something like 2233 Pine Street Nowherevill Bedroom:3 Bathroom:2

I’m a total spreadsheet novice, so pardon my noobism, but:

What would the expression be for X=A & " " & B & " " & “Bedrooms:” C & " " & “Bathrooms:” & D

but all of the Columns would be for that specific row (X3 would pull in A3, and B3, etc).

[EarnestAl]

You are virtually there, in X3 enter. =A3&" "&B3&" "&"Bedrooms: "&C3&" "&"Bathrooms: "&D3

Look up help on concatenate function. Cheers, Al

[oguruma1218]

How do I extrapolate that to all 500 rows, though?

[EarnestAl]

Copy cell X3, hold down Shift key and click cell X503 all 500 cells should be selected, click Paste (Ctrl+V)