Forum Discussion
Ritesh Srivastava
Sep 19, 2018Copper Contributor
Change one column data in to different columns data manipulation ms sql queries
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
input table
Output table
No RepliesBe the first to reply