Google Sheets: How can I Flatten and Split Data while including multiple columns?

Question

I would like to pull data from Google Sheets form responses that include checkboxes. The checkboxes are output into single column cells by commas.

Data/Form Responses sheet: enter image description here

Current and Expected Results enter image description here

Current Formula

=ARRAYFORMULA(TRIM(QUERY(SPLIT(FLATTEN(IF(IFERROR(SPLIT('Form Responses'!E2:E, ","))="",,
 'Form Responses'!B2:B&"×"&SPLIT('Form Responses'!E2:E, ","))), "×"), 
 "where Col2 is not null")))

If anyone could please help I would appreciate it!

Answer 1

SUGGESTION

Perhaps you can try this tweaked formula:

=ARRAYFORMULA(TRIM(QUERY(SPLIT(FLATTEN(IF(IFERROR(SPLIT('Form Responses'!E2:E, ","))="",,TEXT('Form Responses'!A2:A,"MM/DD/YYYY HH:MM:SS")&"×"&'Form Responses'!B2:B&"×"&'Form Responses'!C2:C&"×"&'Form Responses'!D2:D&"×"&SPLIT('Form Responses'!E2:E, ","))),"×"),"where Col2 is not null")))

Demo

---