Repeating rows n times & copying

Closed
Report
-
 patattack -
Hello,

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

Column A Column B
5 5
6 5
7 5
4 6
6
6
7
7
7
4
4
4

2 replies

the second example stuffed up a bit.
this is what it should look like:
Column A Column B
5 5
6 5
7 5
4 6
6
6
7
7
7
4
4
4
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