UDF for Row - Column transpose | Dynamic columns

MS_1

Friends


Please share if anyone has ever written a UDF that does below thing.

Row - column transpose with dynamic number of columns .

Here is the example:




NOTE: THERE COULD BE THE CASE THAT NUMBER OF SUBJECTS MIGHT BE DIFFRENT FOR DIFFERENT STUDENTS.

ALSO, SELECT QUERY SHOULD BE ABLE TO HANDLE DYNAMIC NUMBER COLUMNS WHEN NEW SUBJECT IS ADDED.

Thanks
Mahesh