How to parse "tagged" values into columns

[gioIezzi]

Hi Everyone!

I am trying to convert a data set from tags over to columns. I have already tried the transpose tool along other ones, but I'm only able to do it with 1 line. Whenever I try to add more than one line then it goes crazy!. 

This is how the data comes in:

Name	John
Last Name	Doe
Ammount	120
Name	Lise
Last Name	Stuart
Ammount	30
Name	Pablo
Last Name	Ramirez
Ammount	85

This is how the data should look like:

Name	Last Name	Ammount
John	Doe	120
Lise	Stuart	30
Pablo	Ramirez	85

Thanks in advance!

[AngelosPachis · Accepted solution]

Hi @gioIezzi ,

You will have to create a field to group on before cross tabing your data. You can build this logic with a multi-row formula tool, to create groups of 3 records

Hope that helps.
Angelos

[binuacs]

@gioIezzi Another way of doing this with the tile tool

[Emmanuel_G]

@gioIezzi 

Find in attachement the way of doing that.

Please do not hesitate to mark this answer as solution if it helped.