Eliminate row

[Anonymous]

Hi All

How do I eliminate (delete) row where JO is and need to replicate the same value in RED to underneath 3 row where S1, S2, S3 (Blue) are

basically Delete whole RED circled row, Copy that value to underneath for S1, S2, S3

Thanking you