I must be sooo basic - have only been exploring Alteryx free trial for one hour
I'm trying to prepare some survey data (wide to tale)
From: (statement.xlsx)
total | I Trust Charities More If I Have Heard Of Them | I Feel Confident Donating To A Charity Even If I Haven’t Heard Of Them, If It’s Going To A Good Cause | Charities Are Regulated And Controlled To Ensure That They Are Working For The Public Benefit |
NETT: AGREE (8-10) | 573 | 140 | 333 |
NETT: NEUTRAL (4-7) | 956 | 866 | 1029 |
NETT: DISAGREE (0-3) | 82 | 604 | 249 |
to something like: (output csv)
Questions | Statement | Value |
I Trust Charities More If I Have Heard Of Them | Agree | 573 |
I Feel Confident Donating To A Charity Even If I Haven't Heard Of Them, If It's Going To A Good Cause | Agree | 140 |
Charities Are Regulated And Controlled To Ensure That They Are Working For The Public Benefit | Agree | 333 |
I Trust Charities That Let The Public Know How They Use Their Resources, Including Money From Donations | Agree | 922 |
Charities Spend Too Much Of Their Funds On Salaries And Staff Benefits | Agree | 520 |
Charities Spend Too Much Of Their Funds On Administration | Agree | 576 |
Charities Waste Too Much Money | Agree | 353 |
Most Charities Are Trustworthy | Agree | 327 |
I Trust Big Charities More Than Smaller Ones | Agree | 199 |
I Trust Charities That Provide Services Overseas | Agree | 238 |
I Trust Charities That Provide Services In Australia | Agree | 574 |
I Trust Charities That Provide Services Within My Local Community | Agree | 564 |
I Trust Charities That Are Well-known | Agree | 483 |
I Trust Charities That Have Been Established A Long Time | Agree | 529 |
I Trust Charities More If They Are Clear About How They Are Managed | Agree | 875 |
I Trust Charities To Make A Positive Difference To The Cause That They Are Working For | Agree | 683 |
I Trust Charities That I Have A Personal Connection To | Agree | 542 |
I Trust Charities With Well-known Supporters And Patrons | Agree | 235 |
I Don't Trust Charities That Spend A Lot Of Money On Advertising | Agree | 612 |
I Don't Trust Charities That Pay Sales People To Raise Funds | Agree | 720 |
I Trust Charities To Be Well Managed And Efficient | Agree | 500 |
I Trust Charities To Ensure That A Reasonable Proportion Of Donations Make It To The End Cause | Agree | 601 |
I Trust Charities To Ensure That Their Fundraisers Are Ethical And Honest | Agree | 580 |
I Trust Charities To Act In The Public Interest | Agree | 550 |
I Trust Charities That Have Supported Me Or Close Family Or Friends | Agree | 533 |
Charities Provide An Important Service To The Community | Agree | 819 |
I Trust Charities More If I Have Heard Of Them | Neutral | 956 |
I Feel Confident Donating To A Charity Even If I Haven't Heard Of Them, If It's Going To A Good Cause | Neutral | 866 |
Charities Are Regulated And Controlled To Ensure That They Are Working For The Public Benefit | Neutral | 1029 |
I Trust Charities That Let The Public Know How They Use Their Resources, Including Money From Donations | Neutral | 631 |
Charities Spend Too Much Of Their Funds On Salaries And Staff Benefits | Neutral | 959 |
Charities Spend Too Much Of Their Funds On Administration | Neutral | 930 |
Solved! Go to Solution.
Hi @ffery ,
Here is a workflow for the task
Here is the output.
Hope this helps : )
If this helps please mark the post as solution
Hi @ffery — Try this solution:
If this solves your issue please mark the answer "Solved" with a Like, if not let me know!