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!
Solved! Go to Solution.
Very similar to @DavidP but just grouping on Name as well as using as the field name.
Thanks @DavidP and @jdunkerley79, that works well