UDF for Row - Column transpose | Dynamic columns

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:

image


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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file