Keep the first the last occurrences in column data

The range of column data contains repeated values for which I want to find a formula to keep the first and last occurrences of the repeated values and remove the ones in between.

I attach snapshots for what I am looking for (before and after)

I will be so appreciative if someone can provide us with the right solutions in excel.

I am looking forward to hearing from you soon.