Copying cells from one column to multiple rows in a different column

I have a large data set where I need to take several rows from one column and copy each row n amount of times to a different column. To be specific, lets say in column A, I have:   1 2 3 4   I...