Sort volumes from a random table to a new Table.

Sort random volumes to a new Table. There are prices vs volumes but at times there are no volumes as shown in column B and C. What formula can be used to assemble them in the order they happen ( from top to bottom) as displayed with the new serial number in col G and H. The SN in F is not important but the order is .Please see the attached sheet

Essentially, if there is a way that we can check out and copy down where-ever there is a Volume(in Col C) and the price against it in Col B, then we can also paste it in col G and H.

These two array formulas will do it. In G

=IFERROR(INDEX($B$5:$B$14, SMALL(IF($C$5:$C$14<>"",ROW($C$5:$C$14)-ROW($C$5)+1),ROWS($A$1:$A1))),"")

In H
=IFERROR(INDEX($C$5:$C$14, SMALL(IF($C$5:$C$14<>"",ROW($C$5:$C$14)-ROW($C$5)+1),ROWS($A$1:$A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Why not with an filter?

See theattache file.

See the yellow cells in the attached file.

Please reply.

Thanks for the reply.

Glad I could help.

For the future, please also add to who you are replaying (since you get several responces).