Delete specific cells with shift cells up
Answers to Excel - Get only values from column that are not Zero “0” asked by @CiscoNewb includes ones applying AGGREGATE:
This sample was provided:
ColumnA: 1|0|10|9|2|20|3|5|14|15 ColumnB: 0|5|28|0|20|12|4|0|18|1
For those without the above functions, is there another way, preferably not requiring any function?