Spreadsheet: 870999d1717476088-all-data-in-one-line-needs-to-be-sorted-into-separate-entries-of-the-same-id-for-excel-forum-2-aligw
Sheet: Tab 1 - Current Format

 | QU_1 | QU_2 | QU_3 | QU_4 | QU_5 | QU_6 | QU_7 | QU_8 | QU_9 | QU_10
Record ID | I love this website | I  am a fan of bonjovi | I live in the UK | I do not get sea sick | I am dog lover | I drive a car | I love my job | I have a smarphone | my laptop is old | I love going to the cinemas
1 | Agree | Disagree | Agree | Disagree | Agree | Agree | Agree | Not sure | Agree | Agree
2 | Disagree | Not sure | Disagree | Not sure | Agree | Not sure | Not sure | Not sure | Agree | Disagree
3 | Agree | Disagree | Disagree | Disagree | Disagree | Not sure | Disagree | Agree | Agree | Agree
4
5
6
7
8
 |  | QU_1 | I love this website | Agree
 | 1 | QU_2 | I  am a fan of bonjovi | Disagree
 | 1 | QU_3 | I live in the UK | Agree
 | 1 | QU_4 | I do not get sea sick | Disagree
 | 1 | QU_6 | I drive a car | Agree
 | 1 | QU_7 | I love my job | Agree
 | 1 | QU_8 | I have a smarphone | Agree
 | 1 | QU_9 | my laptop is old | Not sure
 | 2 | QU_1 | I love this website | Agree
 | 2 | QU_2 | I  am a fan of bonjovi | Agree
 | 2 | QU_3 | I live in the UK | Disagree
 | 2 | QU_4 | I do not get sea sick | Not sure
 | 2 | QU_6 | I drive a car | Disagree
 | 2 | QU_7 | I love my job | Not sure
 | 2 | QU_8 | I have a smarphone | Agree
 | 2 | QU_9 | my laptop is old | Not sure
 | 3 | QU_1 | I love this website | Not sure
 | 3 | QU_2 | I  am a fan of bonjovi | Not sure
 | 3 | QU_3 | I live in the UK | Agree
 | 3 | QU_5 | I am dog lover | Disagree
 | 3 | QU_6 | I drive a car | Agree
 | 3 | QU_7 | I love my job | Disagree
 | 3 | QU_8 | I have a smarphone | Disagree
 | 3 | QU_10 | I love going to the cinemas | Disagree
 | 4 | QU_1 | I love this website | Disagree
 | 4 | QU_2 | I  am a fan of bonjovi | Not sure
 | 4 | QU_3 | I live in the UK | Disagree
 | 4 | QU_5 | I am dog lover | Agree
 | 4 | QU_6 | I drive a car | Agree
 | 4 | QU_7 | I love my job | Agree
 | 4 | QU_8 | I have a smarphone | 0
 | 4 | QU_10 | I love going to the cinemas | 0
 | 5 | QU_1 | I love this website | 0
 | 5 | QU_2 | I  am a fan of bonjovi | 0
 | 5 | QU_4 | I do not get sea sick | 0
 | 5 | QU_5 | I am dog lover | 0
 | 5 | QU_6 | I drive a car | 0
 | 5 | QU_7 | I love my job | 0
 | 5 | QU_9 | my laptop is old | 0
 | 5 | QU_10 | I love going to the cinemas | 0
 | 6 | QU_1 | I love this website | 0
 | 6 | QU_2 | I  am a fan of bonjovi | 0
 | 6 | QU_4 | I do not get sea sick | 0
 | 6 | QU_5 | I am dog lover | 0
 | 6 | QU_6 | I drive a car | 0
 | 6 | QU_7 | I love my job | 0
 | 6 | QU_9 | my laptop is old | 0
 | 6 | QU_10 | I love going to the cinemas | 0
 | 7 | QU_1 | I love this website | 0
 | 7 | QU_3 | I live in the UK | 0
 | 7 | QU_4 | I do not get sea sick | 0
 | 7 | QU_5 | I am dog lover | 0
 | 7 | QU_6 | I drive a car | 0
 | 7 | QU_8 | I have a smarphone | 0
 | 7 | QU_9 | my laptop is old | 0
 | 7 | QU_10 | I love going to the cinemas | 0
 | 8 | QU_1 | I love this website | 0
 | 8 | QU_3 | I live in the UK | 0
 | 8 | QU_4 | I do not get sea sick | 0
 | 8 | QU_5 | I am dog lover | 0
 | 8 | QU_6 | I drive a car | 0
 | 8 | QU_8 | I have a smarphone | 0
 | 8 | QU_9 | my laptop is old | 0
 | 8 | QU_10 | I love going to the cinemas | 0
 | #N/A | QU_2 | I  am a fan of bonjovi | 0
 | #N/A | QU_3 | I live in the UK | 0
 | #N/A | QU_4 | I do not get sea sick | 0
 | #N/A | QU_5 | I am dog lover | 0
 | #N/A | QU_7 | I love my job | 0
 | #N/A | QU_8 | I have a smarphone | 0
 | #N/A | QU_9 | my laptop is old | 0
 | #N/A | QU_10 | I love going to the cinemas | 0
 | #N/A | QU_2 | I  am a fan of bonjovi | 0
 | #N/A | QU_3 | I live in the UK | 0
 | #N/A | QU_4 | I do not get sea sick | 0
 | #N/A | QU_5 | I am dog lover | 0
 | #N/A | QU_7 | I love my job | 0
 | #N/A | QU_8 | I have a smarphone | 0
 | #N/A | QU_9 | my laptop is old | 0
 | #N/A | QU_10 | I love going to the cinemas | 0