Concatenation

Hi All,

I need to concatenate values from two rows I tried But I couldn't
able. I'll expalin my situation

I have two columns A and B in which data was there I need result in the col C as described below.

A B Result
93 ---
10 95 9310
20 94 9320
30 96 9330
40 9340
50 9350
60 9360
90 ---
10 92 9010
20 91 9020
30 96 9030
40 9040
50 9050
60 9060
102 --
10 61 10210
20 10220
30 10230
40 10240

My requirement is when a cell in the column A is empty then in column
C I Need concatenation of corresponding Col B value with the column A
values till it finds next empty cell in column A again the process
should repeat once it finds the empty cell in column A.

Could any one can tell me how to resolve this.

Thanks in advace

Regards

Ramana

Hi,

for better understanding I'm Attaching one sample file.

Regards

Ramana

Hi,

Thanks for the immediate reply

But Its not working When A3 is vacant then it should pickup the value from B3 and concatenate B3&A4, B3&A5, B3&A6 till it find a empty cell in the Col A.

If A7 is empty then it should pick the value of B7 and concatenate B7&A8, B7&A9 in the column C

Hope Now I have given a clear Idea about what I need.

Regards

Ramana