PDA

View Full Version : Solved: Concatention Problem



ram117
07-16-2009, 02:58 AM
Hi All,

I'm new to VB Macros and I didn't find any solution in Functions in Excel So I'm Posting this to This forum Hoping that I'll get a solution

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 I need result in the col C as described below.

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

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

mdmackillop
07-16-2009, 05:06 AM
Can you post a workbook with your sample data so we don't need to reproduce it. I don't see any empty cells in Column A in your post.

ram117
07-16-2009, 09:42 PM
Can you post a workbook with your sample data so we don't need to reproduce it. I don't see any empty cells in Column A in your post.

Hi,

Thanks for the reply I got it solved through the functions.

Regards

Ramana

mdmackillop
07-17-2009, 12:18 AM
Can you post your solution for the benefit of others?

ram117
07-17-2009, 10:14 PM
Formula is in Col C1:= if(isblank(A1),"",lookup(2,1/isblank($A$1:$A1),$B$1:$B1)&$A1))