The runtime for my code I wrote takes too long, is there a way tocan you condense?

This is in actuality only 1/3 of the code. I would have to do the same process copying and pasting data if column X and column Y return value same way I did for Column W and dropping it below each other.