Concatenation

**DonkeyOte** · 07-16-2009, 06:02 AM

Ramana your sample is very difficult to comprehend - ie better (always) to post a sample file.

Perhaps based on your narrative... if row 1 is a header than

C1: =IF($A2="","",LOOKUP(2,1/($A$1:$A1=""),$B$1:$B1)&$A2)
copied down

**ram117** · 07-16-2009, 07:00 AM

Hi,

for better understanding I'm Attaching one sample file.

Regards

Ramana

**DonkeyOte** · 07-16-2009, 07:04 AM

In which case, adaptation of original suggestion

C3:
=IF($A3="","",LOOKUP(REPT("Z",255),CHOOSE({1,2},"",LOOKUP(2,1/($A$2:$A2=""),$B$2:$B2)&$A3)))
copied down

**ram117** · 07-16-2009, 07:26 AM

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

**DonkeyOte** · 07-16-2009, 02:08 PM

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

Not at all I'm afraid.

The formula provided generates the exact same results you specify in your file, if they're not correct I suggest a load a sample file which contains the correct desired output.