Generate rows for values in multiple fields

[james204]

Hi there,

I have some data that currently looks like this:

However, I would like to split Paris into two rows, one row for rank B and one for rank C:

I have got close to this by using the Generate Rows tool, so Paris now shows on two separate rows but it contains values for both B and C:

How can I get Alteryx to remove the C from the first row and the B from the second row? Obviously this is only sample data - the real data will include multiple cities and multiple rankings so I need something generic and replicable. Hopefully there is a solution!

[DavidP · Accepted solution]

How about this?

[jdunkerley79]

Very similar to @DavidP but just grouping on Name as well as using as the field name.

[james204]

Thanks @DavidP and @jdunkerley79, that works well