How to Generate - Unique value using Index formula in the Columns Instead of Rows

tamiz.vedachalam

Fruits_Master_List		S. No	Fruits Index
Apple		1	Apple
Mango		2	Mango
Pineapple		3	Pineapple
Cherry		4	Cherry
Mango
Pineapple
Cherry
Pineapple
Apple
Mango

'=IFERROR((INDEX(DISTINCT(COLLECT({Fruits_Master_List}, {Fruits_Master_List}, @cell <> "")), [S.No]@row)), "")

I am using the above-mentioned formula - to generate the fruits unique value

BUT I WANT THE OUTPUT IN THE COLUMNS instead of ROW

S. No	1	2	3	4
Fruits Index	Apple	Mango	Pineapple	Cherry

Let me know if this is possible ?

Paul Newcome

You would put your numbers across the top row and then you would reference those cells. It is the same exact concept as the vertical list.