Pasting values in specific columns

Hi, I have the macro below which counts the uniques values in column G and pastes the number of occurences for each in column Q. However, in column G, it overwrite the data and lists the uniques values. How can I paste that in another column instead?

Please Login or Register  to view this content.