Forum Discussion
Solved
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 Microsoft Support page could I take the unique list of name and display them horizontally, effectively as column headers of a table?
LukeORafferty That would be
=TRANSPOSE(UNIQUE(..........))
LukeORafferty That would be
=TRANSPOSE(UNIQUE(..........))
Ah so simple, thank you! Riny_van_Eekelen
