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

(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.

e.g.

Input:

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 *