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 2 - Format I need

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