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

[FinnCharlton · Accepted solution]

Hi @umarabdulsattar3275 , you need the CrossTab tool:

[binu_acs]

@umarabdulsattar3275 One way of doing this with the Cross Tab

[umarabdulsattar3275]

how I can do without No. column

[umarabdulsattar3275]

How I can do this 

[FinnCharlton]

Hi @umarabdulsattar3275 ,

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

[umarabdulsattar3275]

Thank you so much. I am sorry for confusion. My actual data is this 

Can you please guide me how I can convert it in 4 different columns?

[FinnCharlton]

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