Moving the data to new column based on empty row

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

Moving into different column.xlsx

Common Use Cases

Accepted answers

@SH_94 One way of doing this

Remark_0923.yxmd

All comments

@SH_94 One way of doing this

Remark_0923.yxmd

Thank @binu_acs 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.

Quick Links

Tags

This months top contributors

AkimasaKajitani 389

Hollingsworth 335