using pivot in sql how to split rows as main subject and sub subject of the main subject in single column -


enter image description here

now getting main subject 1 column , sub-subject column want combine 2 in single column

enter image description here


Comments