Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Took me a bit of thought to figure this out without too much brute force. Got a bit more clever on my Transpose and Cross-tabs than in the past
Spoiler
Process:
- Select tool to get rid of the unneeded fields
- Select Records to obtain just the responses
- Record ID to be able to identify individual responses
- Transpose on Record ID
- Text to Columns on ":" delimiter
- Created "Item" fields to use as field name
- Formula to create "Respondent" ID from Name (e.g. extract number from "F2", etc) - that was because the order of my data came out wrong since Name is a text field
- Formula to update "Value" field so it holds all responses to questions
- Cross-Tab on Respondent with Item as column header and Value as data
- Clean-up
- Select tool to get rid of the unneeded fields
- Select Records to obtain just the responses
- Record ID to be able to identify individual responses
- Transpose on Record ID
- Text to Columns on ":" delimiter
- Created "Item" fields to use as field name
- Formula to create "Respondent" ID from Name (e.g. extract number from "F2", etc) - that was because the order of my data came out wrong since Name is a text field
- Formula to update "Value" field so it holds all responses to questions
- Cross-Tab on Respondent with Item as column header and Value as data
- Clean-up
