Test Question Domain Competency "Answer"
231 1 2 6 4 (First Record in the row)
231 2 2 7 3 (Second Record in the row)
So I wanna get the data from that row and add that row to another Table as column. Consider the record from ans1 and now i want to put this data into the column as record for ID 1 then ans2 will be the record for ID2 row for that column.We can identify the column by test number(better option) as the row is the answer for that test number .Basically place entire row as a separate column in another table. and I have to do it for 30 rows. SO we will add 30 columns in second table(Second Image) . Please guide. A direction or 2 or 3 helpful commands will suffice as an answer