How to duplicate a cell value to multiple rows base on a different column

[Didi]

Pls I need help. I am trying to duplicate a row in column2 for specific rows. Like so-

column 1 column 2

A.                01/02/2022

A.                    Null

A.                    Null

B.                03/01/2022

B.                  Null

B.                   Null

how can I duplicate the date to the respective letters in column 1?

[BA_Pete · Accepted solution]

Hi @Didi ,

Select [Column2], then go to the Tranform tab > Fill (dropdown) > Down.

You may need to sort [Column1] ASC then [Column2] DESC bfore this to ensure everything is in the right place.

Pete

[Didi]

Thank you so much BA_Pete. You are a life saver! It worked perfect 👍