Forum Discussion
LukeORafferty
Oct 11, 2022Copper Contributor
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?
LukeORafferty That would be
=TRANSPOSE(UNIQUE(..........))
2 Replies
- Riny_van_EekelenPlatinum Contributor
LukeORafferty That would be
=TRANSPOSE(UNIQUE(..........))
- LukeORaffertyCopper Contributor
Ah so simple, thank you! Riny_van_Eekelen