Index array?

I'm trying to Index a list. The list has a bunch of names, each name duplicated many times. I just want to auto generate a list of each name one time (no duplicates.)

Example Data
John Valencia
John Valencia
John Valencia
John Valencia
John Valencia
John Valencia
John Valencia
Joe Holub
Joe Holub
Joe Holub
Joe Holub
Joe Holub
Joe Holub
Joe Holub
Joe Holub
John Valencia
John Valencia
John Valencia
John Valencia
John Valencia
John Valencia
Joe Holub
Joe Holub
Joe Holub
Joe Holub
Joe Holub
Joe Holub

Formula Used:
=IFERROR(INDEX($Q$5:$Q$603, MATCH(0, COUNTIF($Z$1:Z1, $Q$5:$Q$603), 0)), "")

Results:
John Valencia
John Valencia
John Valencia
John Valencia
Joe Holub
Joe Holub
Joe Holub
Joe Holub
Mario Lucas Peneda
Mario Lucas Peneda
Mario Lucas Peneda
Mario Lucas Peneda
Anthony Goodrich
Anthony Goodrich
Anthony Goodrich
Anthony Goodrich
Scott Nowicki
Scott Nowicki
Scott Nowicki
Scott Nowicki
Pickup Order
Pickup Order
Pickup Order
Pickup Order
Unknown Driver
Unknown Driver
Unknown Driver
Unknown Driver

Problem:
Each name is listed four (4) times - I want it to list each name only one time. A list with no duplicates.

It's been many years since I've done this type of work. I'm rusty and need some help.

Thanks!
Jason

Hi & welcome to the board.
If you have put the formula into Z5 change$Z$1:Z1 to $Z$4:$Z4