No experience, special copy and paste column macro

Its possible...anythings possible with VBA


Can you just confirm step 1, what do you mean by paste into a single column?

are you saying that if in columns B to G you have (I've shown columns seperated by
A;BC;1;EFG;H;AAAAA;

you want it to take that, concatenate the values and output "ABC1EFGHAAAAA" into a cell on the new worksheet?

what i've been doing is manually copy and paste all the columns i want into a single column.
then i select the single column sort it from a through z.
then I insert a heading for the column called Description
Then I use the subtotal command, function is count....then it does the count for me

I've attached another excel sheet to show what the result is suppose to be.

Sorry for all the confusion. I'm pretty bad with explaining things lol