Clear cell contents by text

.Hello
I have names in column A which are duplicated in continuous rows until the next name and so on. How can I get the first name and then delete the same name in the rows below (clear cell contents).

The goal is to have the name appear once in column A until the next name, there can be X amount of rows for the same name that would have to remain.

This:
Rick Data1 Data2 Data3
Rick Data4 Data5 Data6
Rick Data7 Data8 Data9
John Data1 Data2 Data3
John Data4 Data5 Data6
etc.

To be like this:
Rick Data1 Data2 Data3
. . Data4 Data5 Data6
. . Data7 Data8 Data9
John Data1 Data2 Data3
. . Data4 Data5 Data6
etc.

Try this:

Please Login or Register  to view this content.

Thank you, works great!