Unique Values from multiple columns of Table

[chintamani.avinash]

Hello,

As per attached sample file, there are two sheets, sheet 1 is Basic Data and Sheet 2 is Expected Result.
In basic data sheet, Table is given in which header is name of the subject and below it list of teachers is given. One teacher can be seen multiple times at different subjects. As it is sample file, in actual work number of teachers and subject may increase or decrease. Also name of the teacher and subject from basic table may also get replaced. It is because in future teacher or subject may get replace and new teacher and subject may get introduced.

I want to have unique list of teachers in result sheet in given format. Also their name of the subjects will appear next to their name as per given format.

In result sheet, In the blank cell of subject, automatic value 'Nil' will appear.

In Basic data sheet, size of the table will increase or decrease with addition or deletion of the teacher and subject name.

This code will work only in selected areas in result sheet as per given (separate instructions) in the sample file.

Need VBA code for this. I have tried formulas but it is reducing performance/speed of the file.

Thank you for Help.