Ordering cell values according to cell number

Question

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?

score 1 · Accepted Answer · edited Jun 26 '22 at 05:21

1

Try:

=ARRAYFORMULA(SPLIT(FLATTEN(QUERY(TRANSPOSE(REPT(
 IF(A2:O3="",,A1:O1&"×"), LEN(IFERROR(
 REGEXREPLACE(A2:O3, "[0-9]+", )))+1)),,9^9)), "×"))

edited Jun 26 '22 at 05:21

Sunderam Dubey

answered Jun 08 '22 at 16:28

player0

1 Answers1