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.
Hi everyone! I need to transform this table in that way. I've managed to build a pivot ID-Concert, but don't have any idea how to add there type1 and type2. So thanks for any idea!
I've been able to create the pivoted version of what you're trying to achieve. I'm not sure Alteryx supports multiple column headers in the way you're trying to present the data.
Using my method, however, you should be able to then transpose the output table in software such as MS Excel to reach your desired outcome. Not ideal, I know but I'm unaware of another option.