Group By Value then move values to new columns

umarabdulsattar3275

Hi Everyone,

I am new in Alteryx. I want to create new table from column 1 I want to use as header and column 2 as value.

Thank you

Workflow

Output

Transformation

Accepted answers

Hi @umarabdulsattar3275 , you need the CrossTab tool:

All comments

Hi @umarabdulsattar3275 , you need the CrossTab tool:

@umarabdulsattar3275 One way of doing this with the Cross Tab

Cross_Tab_012323.yxmd

umarabdulsattar3275

how I can do without No. column

umarabdulsattar3275

How I can do this

Hi @umarabdulsattar3275 ,

You will need a make a column to group on, I suggest using the tile tool:

Tile and CrossTab.yxmd

@umarabdulsattar3275 , you could also try the make columns tool:

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703