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

Options

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 ?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!