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.
I am working on a excel sheet which needs to be transposed to a normalized way using alteryx tools, but I am unable to achieve that using the transpose and cross tab tools with in the Alteryx. Looking if someone can help me in this?
Here are the sample images of my original excel sheet and the sheet which I need to convert into.
Original format of excel sheet:
Sheet that needs to be converted into:
The challenging part for me was to parse the Classified results and Raw results as a values into separate column "Results".
Can someone help me out in achieving this? Thanks in advance!