SOLVED

Can I use UNIQUE as column headers?

New Contributor

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 Microsoft Support page could I take the unique list of name and display them horizontally, effectively as column headers of a table?

2 Replies
best response confirmed by LukeORafferty (New Contributor)
Solution

@LukeORafferty That would be

=TRANSPOSE(UNIQUE(..........))

Ah so simple, thank you! @Riny_van_Eekelen