Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
YR
Contributor
Contributor

Convert rows to columns

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! 

1 Reply
anat
Master
Master

try using generic load