Forum Discussion

Ritesh Srivastava's avatar
Ritesh Srivastava
Copper Contributor
Sep 19, 2018

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