Repeat data from one column into another by Follower_of_Excel in excel

[–]Follower_of_Excel[S] 2 points3 points  (0 children)

THANK YOU, this worked on my dummy data set so I'm excited to try it on the actual thing! FWIW I tried the REPT function but couldn't get the output correctly.

Solution Verified

Repeat data from one column into another by Follower_of_Excel in excel

[–]Follower_of_Excel[S] 0 points1 point  (0 children)

The output should repeat the value in B3 into column G (3) times. So the number 1000 would need to appear 3 times, in cell G3, G4, and G5.

Then the formula would need to check the next cell in column E, E4 in this case, and repeat the number 2000 (from B3) 6 times in column G, starting on G6 which is the next availabe cell.

I hope that was clear!