Converting Row Values to Columns

[amitsingh88]

Hi,

I have an input table like this-

 And I want table like this from the above table-

How I can do this by using Alteryx? I tried using Cross Tab but it didn't work.

Thanks

[apathetichell]

tile tool - unique value - name

cross tab - tile seq as key column

name as columns

value as value.

[RolandSchubert]

Hi @amitsingh88 ,

to achieve the result using the Cross Tab tool, you need a specific row id. You can easily create an id using the Multi-Row formula tool thereby adding a "row counter" for each [Name]. 

Create a  new filed [RowId] and create a counter for the group (= [Name]).

 

This can be used in the Cross Tab tool as a "group by" field and identifies the rows; even though you use Concatenate as an aggregation method, the group by field leads to one entry per row.

 

It should produce exactly the result you need.

I've attached a sample workflow. Let me know if it works for you.

Best,

Roland