How to generalize macro that Grouped Rows To Delimited String for more then one column

[Einarr]

My data looks like

data.png

My Macro turns the repeated rows of data for the last column into a delimited string


outputhave.png

I can get the macro to create delimited strings for both columns

outputneed.png

But in some projects, I might have 50 columns that I need to run this on

How to generalize this to work on n-Columns

Thanks

Please Login or Register  to view this content.

[nilem]

Hi Einarr,
maybe so

Please Login or Register  to view this content.

[Einarr]

Thank you that works great