omg you are the best (Y), somehow now im being asked for more <.< i'll try to comprehend what u did to adapt it to what i need now.

The problem now is that theres a blank space between the names in the columns. i used ur macro but it grabs also the blanks spaces.