How to transpose a dataset in Alteryx? see attached picture, from left to right result

[yuqin1201]

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.

[grazitti_sapna]

@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.

[flying008]

Hi, @yuqin1201 

The easy way is use macro from gallery like name transpose-excel: 

[binuacs]

@yuqin1201 One way of doing this