How to concatenate cells that meets a specific criteria in threecolumns

  • Thread starter Thread starter ramana
  • Start date Start date
R

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
 
Can you show us how the example worksheet posted should look after the
concatenation?
 
Can you show us how the example worksheet posted should look after the
concatenation?
Click to expand...

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,

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

Thanks in advance

Regrds

Ramana
Click to expand...

Hi All,

My result should look like this

A B Result

Thanks in advance

Regards

Ramana
 
Hello,

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

Regards,
Bernd
 
Hello,

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

Regards,
Bernd
Click to expand...

Hi Bernd,


Thanks for the solution its working perfect.

Regards

Ramana
 
Back
Top