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!
