Combine multiple rows into one row

[nexbelgium]

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

It's a kind of transpose on the 4 first rows to be repeated. If it were only 2 'columns' per record, I could do that with the multi-row formula, taking the [row-1], but the more columns I add per record, the more complex it becomes.

Many thanks

[Kenda · Accepted solution]

Hey @nexbelgium! The key is to add a field that you can group by before cross-tabbing. Try the attached workflow and see if that's what you're looking for. Hope this helps!

[nexbelgium]

Great, thanks it works!