How to use split text to column in Google Sheets

Question

I want to split text in column:

This is link to my spreadsheet: https://docs.google.com/spreadsheets/d/1uSgHy_RR2Yk30eP0zq-K9W2f4_JgcuiEMDHGA-yQrRg/edit?usp=sharing

Answer 1

Try below formula. See you google-sheet.

=QUERY(ArrayFormula(SPLIT(FLATTEN(SPLIT(A2:A4,", ")&"@"&B2:B4&"@"&C2:C4),"@")),"where Col3 is not null")