Moreover, an actual example would be the following:

R/C | A | B | C | D | E |

1 | {0,0,0,44,31,25,53,12,0,0,0,0} | => | {0,0,0,12,25,31,44,53,0,0,0,0} | | |

2 | |||||

3 | |||||

4 | |||||

5 |

<tbody>

</tbody>

Where A1={0,0,0,44,31,25,53,12,0,0,0,0}

What Excel formula would I use that would take the array in A1 and sort only the non-zero values (44,31,25,53,12) and keep the same number of zeros in their same positions, so as to return the desired result that I've entered in to C1?

Where C1={0,0,0,12,25,31,44,53,0,0,0,0}