Survey Data - change from rows to columns

[dbhamber]

Hi, I have been trying to use transpose, cross tab, select data. Just cannot get my head around it

I have got Survey data that is in Rows I need to turn the column Question into Headers, there are 10 question and these will be repeated for each person.  I can remove columns Question Type and Number. 

Any help will be appreciated, just trying to get to grips with Alteryx.

Thanks

Disham

Question Type	Number	Learner Answer Text	Question	%	Answer
Multiple Choice (Single Answer)	1	Strongly agree	Login Process	75%	It was easy to log on and access the Virtual Classroom session...
Multiple Choice (Single Answer)	2	Strongly agree	Course Experience	75%	I could hear clearly throughout the session...
Multiple Choice (Single Answer)	3	Strongly agree	Course Experience	75%	I could clearly view all visuals and media throughout the session...
Multiple Choice (Single Answer)	4	Strongly agree	Course Content	75%	The information shared in the session was relevant and useful...
Multiple Choice (Single Answer)	5	Strongly agree	Course Content	75%	The questions posed were relevant and helped to focus my attention...
Multiple Choice (Single Answer)	6	Strongly agree	The Trainer	75%	The trainer was knowledgeable...
Multiple Choice (Single Answer)	7	Strongly agree	The Trainer	75%	The trainer was engaging...
Free Text/Comments	8	socail media is the way forward	Overall	75%	What key learning shared in this session will help you in your role?
Free Text/Comments	9	no	Overall	75%	What would your suggestions be for improving the session?
Multiple Choice (Single Answer)	10	10 - Very Likely	Overall	75%	How likely are you to recommend others to attend this course?

[mceleavey]

Hi @dbhamber ,

I'm not sure of your requirements, can you please provide a mock up of what you are trying to show from that data?

M.

[atcodedog05]

Hi @dbhamber 

Can you provide sample data and expected output.

[Luke_C]

Hi @mceleavey 

I agree with @mceleavey, it sounds like the cross-tab tool should get you what you need. I'm just not clear what data you want in each of these new columns.

https://help.alteryx.com/current/designer/cross-tab-tool

[dbhamber]

Hi,

Its Friday. Let me explain the data in column Questions needs to be the heading:

The survey answers will fall in line with the questions, I hope that makes sense. See attached.

Thanks again

Disham

[apathetichell]

Is this what you want?

[atcodedog05]

Hi @dbhamber 

Here is how you can arrive to the excepted output from the given data.

Workflow:

1. I am taking each required columns separately and converting them to column with number as header

2. Later i unioning the rows in order

3. While outputting i am configuring skip field names this way the header which is numbers wont be outputted.

Output:

Hope this helps 🙂