I need a function to do the following task.
values in Col A1 to A6 are 2500,0,65,550,0,900
I need a function to transform these vales in Co B1 to B6 like this:

B1=2500
B2=65
B3=550
B4=900
B5=blank
B6=blank
please don't suggest to use filter,sort options or using a macro.
I am not expert in row number identification basing on condition.I think row
and match function will give the appropriate results ,what I need.