Pivot values to columns

Hi,

I have an ID with 3 corresponding questions and a rate :

 ID   QUESTION   RATE

A1      Q1                 2

A1      Q2                 3

A1      Q3                 1

I would like to have this result :

ID   Q1   Q2    Q3  

A1   2      3       1

But I am not able to do it because I can't use RATE in "Values Column", why ? How can i do it, please ?

Thank you !