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

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 ?

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.