I have a column QA which contains data of feedback data which is Question and Answer in attached format. every question and Answer is in one column only. So I want to analyse this feedback data. To analyse data, First I need to break /segregate all Question and Answers in to different column which I am expecting as OUTPUT.
Please provide your inputs in MS sql queries or in excel.
Input Table
Output table
