In this thread I got the correct answer, but when I delete the values in columns B and C there are no results

CodePudding user response：

use:

=INDEX(SPLIT(FLATTEN(FLATTEN(
 FILTER(A2:A, A2:A<>"")&     IF(LEN(TRIM(QUERY(B2:B,,9^9))),"×"&TRANSPOSE(
 FILTER(B2:B, B2:B<>"")), ))&IF(LEN(TRIM(QUERY(C2:C,,9^9))),"×"&TRANSPOSE(
 FILTER(C2:C, C2:C<>"")), )), "×"))