I need to duplicate rows (without VBA), based on a cell value (column C in the example below). I found the formula below and it works in duplicating the rows, but I need the rows in the original order, not as per the actual results below:

Formula:

=SORT(CHOOSEROWS(B3:C7, TOCOL(IFS(C3:C7>=SEQUENCE(, MAX(C3:C7),,1), SEQUENCE(ROWS(B3:B7))), 2)))

Rows to duplicate:

Actual Results:

Expected results:

​I need to duplicate rows (without VBA), based on a cell value (column C in the example below). I found the formula below and it works in duplicating the rows, but I need the rows in the original order, not as per the actual results below: Formula:=SORT(CHOOSEROWS(B3:C7, TOCOL(IFS(C3:C7>=SEQUENCE(, MAX(C3:C7),,1), SEQUENCE(ROWS(B3:B7))), 2))) Rows to duplicate: Actual Results:  Expected results:    Read More

​