It is delimited but only giving three variables with all the data in one column. Basically the mix of numbers and letters at the start is V1 - this is the encrypted participant ID, V2 - question number, V3 - question score/response. So the first 57 lines equal one person, then next 57= particpant 2, and so on. The problem was/is the data layout. (see image below)
I need to restructure my data so that V1 (ID) is collapsed so its one line, then V2 (Question) is extended across the variables such that the variables read - V1 (ID), V2 (question 1), V3 (question 2), V4 (question 3)... and so on. with the scores aligned under the respective question.
Next question is- How do i do that? Sorry for being an imbecile
You do not have the required permissions to view the files attached to this post.