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

Question

Pls I need help. I am trying to duplicate a row in column2 for specific rows. Like so-column 1 column 2A. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/02/2022A. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NullA. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NullB. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03/01/2022B. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NullB. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Null&nbsp;how can I duplicate the date to the respective letters in column 1?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

ba_pete · Accepted Answer

Hi&nbsp;Didi&nbsp;,
&nbsp;
Select [Column2], then go to the Tranform tab &gt; Fill (dropdown) &gt; Down.
You may need to sort [Column1] ASC then [Column2] DESC bfore this to ensure everything is in the right place.
&nbsp;
Pete

Forum Discussion

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

2 Replies

Related content

Duplicate ranking

Difference between Reference and Duplicate

remove duplicate value within a row

Removing Duplicates

How to combine 2 tables with different column names and multiple duplicate rows