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-c5a...