getting the first and last value out of a non continious data set

[withy]

imagine you have column A

1
3
5

7
6
1
8


6
9
8

i want the numbers 1,5,7,8,6,8 to be printed into column b. make sense?

i am taking the starting and ending values of a non continuous data set. so far i have tried using a for next loop but i can only get the first value. i'm jsut stuck. ANY help is welcomed!

thanks in advance mike.