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.
Hello, how can I transpose this in Alteryx?
This is how I want it to be:
This is what I have in Alteryx now, how can I transpose it to be like the table above?
Here's a solution:
- Transpose grouping by Year
- Cross-Tab values grouping by Name field generated
- Select Tool to rename Name field by Year
How can I arrange the rows such as the country, ID comes after the year just as my example shows?
I use Tile Tool to organize rows and sort them in order.
See flow attached.