i plot an x/y map in my rows (8) and columns (49);

I want to get a list that has the information from column 2 and add to the information of all other columns (when there is a value in the cell)
Ex:

column 2 COLU 3 COLUMN 4
A 21
B 22
C 21 22

THEN I WANT TO HAVE PASTE SOMEWHERE DOWN:

A21
C21
B22
C22

This is what I've done so far (a little messed up too)... any suggestion in how to make it happen?

'Starting Row
x = 2
y = 3
Z = 10

For Each Cells(x, y).Value <> ""
Cells(Z, 2).Value = Cells(x, 2).Value + "" + Cells(x, y).Value

x = x + 1
y = y + 1
Z = Z + 1

Loop

y = y + 1

End Sub