(Solved) – VBA Excel grouping two columns to shrink row count


I try to find a vba solution for the following problem:

I have two columns and try to group column1 in a comma separate way to have less rows.



enter image description here

Output should be:

enter image description here

I tried to do it with Autofilter, but It take too long (about 300.000 Rows). Is there any better solution that task?

Leave a Reply

Your email address will not be published. Required fields are marked *