Activate inserted column for concatenation

I am having some trouble with this code and haven't been able to find a solution. I have two columns (Group and ***) and they appear multiple times in the spreadsheet. The spreadsheet comes from another program so I can't change it, but can manipulate once I have it. I need to concatenate the Group and *** into 1 column then delete the unnecessary columns. I can't figure out how to activate the inserted blank column as the range to do the concatenation. Any help would be greatly appreciated.

Please Login or Register  to view this content.

Hi

Can you put up a sample file with 2 sheets. The first sheet shows your original format, and the second sheet shows the output format you want to achieve.

rylo