We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Row data into columns

bbaisil
7 - Meteor

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 ?

3 REPLIES 3
grazitti_sapna
17 - Castor

@bbaisil, give this a try.

grazitti_sapna_0-1658985571698.png

 

Thanks!

Sapna Gupta
binuacs
21 - Polaris

@bbaisil Another way of doing this

 

binuacs_0-1658988368315.png

 

Kinga
8 - Asteroid

@bbasil

Third version of solution:

Kinga_0-1659008892181.png

 

Labels
Top Solution Authors