Repeating rows n times & copying Closed

Question

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

Configuration: Windows 7 / Internet Explorer 8.0

patattack · Answer

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

patattack · Answer

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

Repeating rows n times & copying

2 responses

Similar discussions

Subscribe To Our Newsletter!