I have two columns:
Column A Column B 1 Course ID Professors <---- (Column Headers) 2 1179/03 Professor-1 3 1179/03 4 1179/03 5 1300/20 Professor-2 6 1300/20 Professor-3 7 1300/21 Professor-2 8 1300/21 Professor-3 9 1300/21 Professor-4 10 1300/21 Professor-4 11 1300/21 Professor-4
Where, to each Course ID can be multiple Professors assigned.
In another part of the same sheet I have a list of Course IDs and I want to insert the assigned professors by means of a formula:
Column D Column E 1 Course ID Professors <--- (Column Header) 2 1179/03 Professor-1 3 1300/20 Professor-2, Professor-3 4 1300/21 Professor-2, Professor-3, Professor-4
I will manually provide the data in the A, B and D columns, then I want to get the results in the E2, E3, E4 by means of
My limit is that, I am not able to add any new column, and possibly, restrict users to sort data according to a certain column.
Can anyone help me, please.