Very beginner - transpose wide to tall survey data

[ffery]

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

[atcodedog05 · Accepted 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

[vizAlter · Accepted solution]

Hi @ffery — Try this solution:

If this solves your issue please mark the answer "Solved" with a Like, if not let me know!