Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table that holds data about customer's survey like this:
Customer_ID | Qusetion_ID | Answer |
11 | 1 | 7 |
11 | 2 | 7 |
11 | 3 | 8 |
12 | 1 | 9 |
12 | 2 | 9 |
12 | 3 | 8 |
13 | 1 |
10 |
and I would like to create a table that shows the details this way:
Customer_ID | Qusetion_ID=1 | Qusetion_ID=2 | Qusetion_ID=3 |
11 | 7 | 7 | 8 |
12 | 9 | 9 | 8 |
13 | 10 |
|
|
how can I do it?
I've tried to add new columns for each question, but all i've got is:
Customer_ID | Qusetion_ID=1 | Qusetion_ID=2 | Qusetion_ID=3 |
11 | 7 | ||
11 | 7 | ||
11 |
|
8 |
|
12 ..... |
9 |
|
|
Thank you for the help!
try using generic load