Combine cell value to one cell based on Row matching

[harryisurs]

Hi Guys

I am new to excel programming

Just trying to understand if there is a way i can combine cells in a column based on a value of a row column

I am attaching an example data and expected result

Can someone help please

Regards

Harry

[jindon]

Try the attached

[harryisurs]

Hi Jindon

This is awesome.... Saved me so much...

Thank you

Harry

[harryisurs]

Hi Jindon

Thanks for the code but when i use it for the bigger data it gives me error for undefined object

Also I was getting VBA error 400

Can you please advise what is the reason..

[jindon]

I don't get error....


When you debug, which line was hi-lited?

[harryisurs]

Here is the line

txt = Join$(Array(a(i, 1), a(i, 2)), ";;")

Also get the TYPE mismatch error
as the data I am using is a little different
would that make a difference

and I have 45k rows

[jindon]

Don't your data have Error value?
If so, it will raise the error.
Insert one line

Please Login or Register  to view this content.

And Number of rows shouldn't matter.

[harryisurs]

Thanks Jindon
You are a star...Just a quick questions how I can understand better on this code.... as to how is it working...
And is there a way to find where the error is in the data
Regards

[jindon]

Please Login or Register  to view this content.

1) Concatenate Col.A & Col.B as a unique key.
2) If same key found, concatenate Col.D.
That's all.

[harryisurs]

Thanks Jindon
I will test this ...
What if I have to increase the number of columns to match. Where do I make changes in ARRAYS

Regards

[jindon]

For unique identifier?
This is the line.
Add the col.ref like ,a(i,3)
3 for col.C in your case.

Please Login or Register  to view this content.