Forum Discussion

Didi's avatar
Didi
Frequent Visitor
3 years ago
Solved

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

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.    ...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    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

BA_Pete's avatar
BA_Pete
Super User
3 years ago

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's avatar
Didi
Frequent Visitor
3 years ago

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