I have a data set with 3 columns. The first column is a non repeating sequential set (1, 2, 3, etc), the second and third columns contain a comma separated set of numbers related to the number in the first column.
Example:
COLUMN 1 COLUMN 2 COLUMN 3 1 1, 3, 5 2, 4, 6, 10 2 2, 3, 6, 8 3, 6, 9 3 1, 3, 5, 7 2, 9, 10
I want to be able to enter a selection of numbers from column 1 into a separate table and have the related numbers from the second and third column populate without duplicating repeated numbers - Example based on data above (Bold numbers in column 1 are entered by the user):
COLUMN 1 COLUMN 2 COLUMN 3 1, 2, 3 1, 2, 3, 5, 6, 7, 8 2, 3, 4, 6, 9, 10
Can anyone recommend how I can make this happen automatically?
Many thanks in advance.
Bookmarks