DATA ARRANGMENT (HELP REQUIRED)

[oiciadteam]

Hello Everyone, 

Can any one help me solve the below problem. Currently my data looks below

I want the data in one line. For example to bring the 1 & 2 record in one line, based on the second column, help me out.   

[oiciadteam]

Hi, 

Can you share with me the Alteryx workflow which you showed in the picture. 

Kind Regards

Rehan

[Per]

Hi @oiciadteam 

I am not at my computer, but you should be able to recreate my config using the picture. Is it causing issues?

[oiciadteam]

Hi Per, 

Please share once you back, I will, because I believe the solution which you presented will work.

[Per]

Hi @oiciadteam 

Here you go. Let me now if it works for your purpose