Forum Discussion

jeffheenan's avatar
jeffheenan
Copper Contributor
Oct 07, 2020

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

 

In column B, I would need:

 

1

1

1

1

2

2

2

2

3

3

3

3

etc.

 

As my actual "column A" data set has thousands of values, I was hoping to find some way to automate this process with a formula or macro.

 

4 Replies

Resources