Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Transpose Data

kaushik_birmiwal
7 - Meteor

Hi All,

 

I have about 500 files in the following format:

Question NoQuestionResponseCommentsResponseComments
1.1.What is your nameKaushik John 
2.1.What is your ageXX XX 
2.2.Which school did you attendAbc Abc 
2.2.1.What marks did you obtain in school70% 90% 
2.2.2.Did you attend collegeNoReason for not attending collegeYes 

 

 

I want the data to transposed in the following format:

1.1. 2.1. 2.2. 2.2.1. 2.2.2. 
What is your nameCommentsWhat is your ageCommentsWhich school did you attendCommentsWhat marks did you obtain in schoolCommentsDid you attend collegeComments
Kaushik XX Abc 70% NoReason for not attending college
John XX Abc 90% Yes 

 

I have tried multiple approached however, I am unable to crack this. Can someone help me on this one? 

 

Thanks,

Kaushik

 

 

2 REPLIES 2
PhilipMannering
16 - Nebula
16 - Nebula

Alteryx doesn't really do nested headers, but maybe this is good enough?

 

PhilipMannering_0-1574425799129.png

kaushik_birmiwal
7 - Meteor

hi Philip,

 

Thank you so much for your response. This is super useful - I can then use Excel for quick formatting.

 

However can you help me with the updated table as well?

Sharing it again on this message.

Question NoQuestionResponseCommentsResponseComments
1.1.What is your nameKaushik John 
2.1.What is your ageXX XX 
2.2.Which school did you attendAbc Abc 
2.2.1.What marks did you obtain in school70% 90% 
2.2.2.Did you attend collegeNoReason for not attending collegeYes 

 

Thanks,

Kaushik

Labels