Moving the data to new column based on empty row

[SH_94]

Dear community,

Would like to seek for help on how to moving the data to new column for the example below: The concept is if the column under GL is empty ( it may have multiple empty rows), then the extract the data from the first empty row in the description column copy to new column called " Remarks". 

Many thanks

[binuacs · Accepted solution]

@SH_94 One way of doing this

[SH_94]

Thank @binuacs  for the great idea on how to massage the data . I understand the concept and will apply it my cases.

Thanks again for the sharing.