How to repeat numbers

[Ahasan13]

Hi all,

So this is how my data set is below. I want the number from column B to be repeated in column A (not the dates only the number). Until it hits a different number, then that new number should repeat and so on. How do I do this please help? 

[davidskaife]

Hi @Ahasan13 

Is this not the same question that you asked in this thread - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Pulling-data-from-one-column-to-anothe... which had some solutions provided?

[Felipe_Ribeir0]

Hi @Ahasan13 

One way of doing this (dummy data):

[ShankerV]

Hi @Ahasan13 

As my friend DavidSkaife mentioned, seems this thread is duplicated with the previous thread.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Pulling-data-from-one-column-to-anothe...

Thanks

Shanker V