I have an excel sheet which has a lot of different columns..
what I want is to copy all the rows n number of times and paste it in another column on the same page.
My columns are between 600 to 1000 lines long and I would like to copy them all.
for example my data would be:
Column A
5
6
7
4
and I want it to be copied 8 .etc times to a new column.
so it would look like
for some reason my example won't work.
but bascially its the same rows in column A
and the repeated rows from column A in column B going down the entire way
