Hi Ainsley,
Thank you for your query.
Since the Columns are just fields, you can change the Field name for the column to update the Column name in the view.

I have changed the Account Name field to just "Name" and Added my name to the Primary contact field.