Home » Other » General » Concatenate
Concatenate [message #104088] |
Tue, 27 July 2004 03:40 |
krishna murthy
Messages: 3 Registered: January 2002
|
Junior Member |
|
|
- value -
- quantity -
- des1 -
- des2 -
- des3 -
- des4 -
- des5 -
- des6 -
- des7 -
- result -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- res1 -
- 4 -
- r1 -
- r3 -
- r4 -
- r2 -
- -
- r7 -
- r8 -
- r1,r3,r4,r2,,r7,r8 -
- res2 -
- 5 -
- r13 -
- r1 -
- r3 -
- r2 -
- r8 -
- r6 -
- -
- r13,r1,r3,r2,r8,r6,r7,r4,r12,,,,,, -
- -
- -
- -
- r7 -
- r4 -
- r12 -
- -
- -
- -
- -
- res3 -
- 2 -
- r1 -
- r3 -
- r2 -
- r5 -
- r8 -
- r11 -
- r7 -
- r1,r3,r2,r5,r8,r11,r7 -
- res4 -
- 7 -
- r3 -
- r5 -
- -
- r7 -
- -
- -
- -
- r3,r5,,r7,,,, -
- res5 -
- 5 -
- -
- r5 -
- -
- -
- r2 -
- -
- -
- ,r5,,,,r2,,, -
I I am Creating an excel sheet as mentioned above
-
result comlumn will contain the contenated data of the columns before that
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
I have the macro to add the data into result column, but the comma is added to the result when there is a blank cell,
So I need a Macro to concatenate all the values in to result column without an extra comma for blank cell,
if any row in value is empty the valuew of that row should be added to theprevious row's result
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- -
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
|
|
|
Goto Forum:
Current Time: Mon May 20 07:44:40 CDT 2024
|