Dynamic unique lists

[sadavies2906]

Hi all
I am trying to create a series of dynamic lists with data from a table searching on 1 criteria to return a second set of data

Example data set

Make Item
200mm ICP module
300mm DEP module
200mm DSiv module
200mm DEP module
300mm Synapse module
200mm DEP module
300mm ISOPOD module

The lists would then need to look like this

200mm 300mm
ICP module DEP module
DSiv module Synapse module
DEP module ISOPOD module

The source data is in a table that as it gets added to the 2 lists need to auto update. The search field for each list needs to be the Make data in the table.

Prefer if it isn’t in a CSE array format

Regards
Stephen

 

[sadavies2906]

Thanks PGC works perfectly

 

[pgc01]

You're welcome. Thanks for the feedback.