Help !

ramarora1985

This query was posted by one of the user@nexbelgium.

Being Fresher and new to Alteryx I was  just trying to practice the same :

Is there any way that we can obtain the solution without using multi row formula option.. The only solution given contains multi row formula which is been attached below

Hi,

I would like to combine records that I receive in multiple rows into one row.

In short, this is my input:

UserName	Michael
Status	Active
Team	Sales
Location	France
UserName	Thomas
Status	Not Active
Team	HR
Location	Belgium
UserName	Bob
Status	Active
Team	HR
Location	Spain

And this is the what I would like as output:

UserName	Status	Team	Location
Michael	Active	Sales	France
Thomas	Not Active	HR	Belgium
Bob	Active	HR	Spain

Appreciating support 

Regards

combine rows.yxmd

paulfound

Hi @ramarora1985 

Here is another solution using the tile tool.

Ultimately you can do this a few different ways.

Don't forget to mark as complete if your question is answered.  

ramarora1985.yxmd