Add unique variables in a column to the end of a dataset to form column headings

[EmAnna]

Hi, 

New to Alteryx, but wanting to add unique variables in a column (Brand) to the end of a dataset to form column headings. Currently I have 'duplicate' rows (aka 2 or more of the same 'Name').

Atm, my data looks like the below: 

Want it to look like this: 

Thanks!

[JamesCharnley]

Hi @EmAnna 

Something like this should do the job. I've just found the counts in a summarize based on name and brand (essentially just giving us a field to populate cells in the next step), then cross-tabbed so the headers are the brands, and the count is the values, then turned the nulls into 0.

[JBLove]

@EmAnna  - Try out the Cross Tab Tool.  First use a Formula tool to hardcode a 1 on each row of data and call it count.  Then use a Cross Tab Tool and group by Name and Brand, use Location for the Column Headers and Count as the value under the new Columns.  For your aggregation method use Sum.

Good luck!

[afv2688]

Hello @EmAnna

Would this work for you?

Regards

[binuacs]

@EmAnna One way of doing this

[Jonathan-Sherman · Accepted solution]

Hi @EmAnna,

You could achieve this using the crosstab tool to help create the analysis:

[EmAnna]

Thanks all for the above - solved!