How to concatenate cells that meets a specific criteria in threecolumns

[ramana]

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

 

[Rick Rothstein]

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

 

[Ramana]

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

Hi All,

Could any one tell me how to send a example Excel sheet to in the
forum.

Thanks in advance

Regrds

Ramana

 

[Ramana]

Hi All,

   Could any one tell me how to send a example Excel sheet to in the
forum.

Thanks in advance

Regrds

Ramana

Hi All,

My result should look like this

A B Result

Thanks in advance

Regards

Ramana

 

[Bernd P]

Hello,

Enter into C1:
=IF(ISBLANK(A1),"",LOOKUP(2,1/ISBLANK($A$1:A1),$B$1:B1)&A1)
and copy down.

Regards,
Bernd

 

[Ramana]

Hello,

Enter into C1:
=IF(ISBLANK(A1),"",LOOKUP(2,1/ISBLANK($A$1:A1),$B$1:B1)&A1)
and copy down.

Regards,
Bernd

Hi Bernd,


Thanks for the solution its working perfect.

Regards

Ramana

 

[Bernd P]

Hello Ramana,

You are welcome.

Regards,
Bernd