Is there a way to Split strings in a google sheet cell into multiple rows?

Example:

CodePudding user response：

use:

=INDEX(IFERROR(SPLIT(FLATTEN(FLATTEN(
 FILTER(A2:A; A2:A<>"")&"×"&TRANSPOSE(
 FILTER(B2:B; B2:B<>"")))&"×"&TRANSPOSE(
 FILTER(C2:C; C2:C<>""))), "×")))