Can you show us how the example worksheet posted should look after the
concatenation?

--
Rick (MVP - Excel)


"ramana" wrote in message
...
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

A B
93
10 95
20 94
30 96
40
50
60
90
10 92
20 91
30 96
40
50
60
102
10 61
20
30
40

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