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