Copy and paste the Row data in column based on specific data

[Alteryx_Geek]

Hello,

Can anyone help me with this below ?

I have the data in Row and column format as shown in below,

              Column 1          Column 2

Row 1     Apple 1

Row 2     Banana             

Row 3     Orange              

Row 3     Strawberry        

Row 4     Pineapple         

Row 5     Apple 2

Row 6     Banana             

Row 7     Orange             

Row 8     Strawberry       

Row 9     Pineapple         

Now I want to have the output as below,

              Column 1          Column 2

Row 1     Apple 1

Row 2     Banana             Apple 1

Row 3     Orange              Apple 1

Row 3     Strawberry        Apple 1

Row 4     Pineapple         Apple 1

Row 5     Apple 2

Row 6     Banana             Apple 2

Row 7     Orange             Apple 2

Row 8     Strawberry       Apple 2

Row 9     Pineapple         Apple 2

Would be really appreciated if someone can help me in figuring this out 

[binuacs · Accepted solution]

@Alteryx_Geek One way of doing this

[Alteryx_Geek]

@binuacs - Thanks, this works perfect.