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?

--
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

On Jul 16, 11:32*am, "Rick Rothstein"
wrote:
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

Hi All,

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

Thanks in advance

Regrds

Ramana

On Jul 16, 12:32*pm, Ramana wrote:
On Jul 16, 11:32*am, "Rick Rothstein"



wrote:
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 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


Could any one can tell me how to resolve this.

Thanks in advace

Regards

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
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


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

On Jul 16, 3:58*pm, Bernd P wrote:
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