Have a design related question.
The image shows a sample table sorted according to the column 'Position'. How would one sort the column according to 'Office', with the fields having multiple values.
The solutions I have, at the top of my mind - is. 1. Duplicate rows as user sorts it by Office. Hence a row with 3 values under Office, will appear 3 times in the list. :-/ 2. Have 1 main value (Office eg. Tokyo) and the others are secondary values (eg. Bombay,London) so the sorting gets done by the main value only.
Any solutions, suggestions?