created more columns

Question

I have a database with the names of people who donated; the donations could have different purposes and be produced by the same person.

My problem is that for each donation, I have a new row with the same name but a different "purpose" for those who donated for multiple purposes.  How do I stop the name from repeating on various rows and create "purpose1, purpose2, Purpose3" columns? Purpose 3 is the last column.

Qiu · Answer

@AnwarAlyafei 
I feel the data for Purpose is not really Purpose per se. 😁 so maybe it is more something like this?

0801-AnwarAlyafei.yxmd

Yoshiro_Fujimori · Answer

Hi @AnwarAlyafei ,

As @CoG suggested, that would be a use case of Cross Tab tool.

First you may check the interactive lesson https://community.alteryx.com/t5/Interactive-Lessons/Changing-Data-Layouts/ta-p/82876.

A sample workflow is attached for your reference.

Good luck.

Input Data

NameAmountPurposea1purpose1a2purpose2a3purpose3b4purpose1b5purpose2b6purpose3c7purpose1c8purpose2c9purpose3

Workflow

Configuration

Output Data

Namepurpose1purpose2purpose3a123b456c789

CrossTab.yxmd

CoG · Answer

Have you tried using the Cross Tab Tool? If you could provide an excel file with sample input and output, more help can be provided.