UNIQUE function in Glide

Ask for Help
2

Creating a unique array is quite simple, and requires two columns:

  • Create a Lookup column that targets your Data column
  • Use a Unique Elements column that targets the Lookup column

If you then need to expand the array into a list that spans multiple rows, you will need some extra columns:

  • Add a RowIndex column to number your rows from 0-N. You can either do that manually, or use the second method described here.
  • Add a Single Value column. It should target your Unique Elements column, taking N from start, where N is your RowIndex column.
2 Likes