How Do I Remove Duplicate Items From My Lookup Table?

Issue

I'm using an Entity Lookup Table to look up inventory information. There are multiple inventory items for each entity. This results in multiple items in each cell (and/or each downstream lookup cell). I want to split this information so that there is only one item per cell.

Environment

All Benchling environments

Cause

It is expected behavior for lookup tables to aggregate values, and there's currently not a way to modify this functionality.

Resolution steps

Summary: Create a second lookup table (an inventory lookup table), autofill the containers from the first table into the second table, and create additional lookup columns as needed.

Steps:
-Insert a lookup table. In the 'Insert Lookup Table' modal, choose 'Inventory Table'.
-On the new table, click Add (the '+' button directly to the right of the table name), and select 'Add From Structured Table'.
-In the 'Add From Structured Table' modal, select the lookup table that had multiple items per cell, and select the column with your inventory items. These options may already be selected for you, if only one applicable table and column exist.
-Create additional lookup columns in the new table as needed by right clicking the column header, selecting 'insert lookup column', and selecting configurations as desired.

video tutorial (one step per gif):

insert lookup table