I have some data spread through different cells. Some cells have comma separated values.
I have included an example that can be seen in the link.
I need to match the data with cell number and show them in the results section as in the example sheet.
How can i achieve this outcome? a little help please. thanks.
>Solution :
try:
=ARRAYFORMULA(SPLIT(FLATTEN(QUERY(TRANSPOSE(REPT(
IF(A2:O3="",,A1:O1&"×"), LEN(IFERROR(
REGEXREPLACE(A2:O3, "[0-9]+", )))+1)),,9^9)), "×"))
