This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!