How to transpose multiple columns and repeat specific cells

user_19749677 0
Viewed 66

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

Example:

Example image

google-sheets-formula flatten transpose google-sheets arrays
1 Answers

use:

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

enter image description here

user_56326290
Related