Row data into columns

[bbaisil]

Hi All,

I have a question. My data look like below.

Student ID grade 

1                 A

1                 B

1                 C

2                 D

2                  F

3                  A

I need to make a single row for a student, so that I get like

Student Id   grade 1 grade 2 grade 3

1                    A            B        C

2                   D             F

3                   A

I have lot f other columns too. But I can include that if I can get this answer.

Can anyone help ?

[grazitti_sapna]

@bbaisil, give this a try.

Thanks!

[binu_acs]

@bbaisil Another way of doing this

[Kinga]

@bbasil

Third version of solution: