Hi I want to change the left dataset to the right, I can do it in one clock in excel. how can I do it in Alteryx? I found it is very difficult to do so.
@yuqin1201 , you can use Cross-Tab tool to do this. It will change the data alignment from horizontal to vertical. Please find below the configuration to do this. You need to select the header column and data column and then any aggregate function.
