Can I use UNIQUE as column headers?

As far as I can see the UNIQUE function always fills down. Is there a way/workaround to fill right instead? I.e. in the example from the https://support.microsoft.com/en-us/office/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e could I take the unique list of name and display them horizontally, effectively as column headers of a table?