Building an order summary

[Closed]
Report
-
Hello,

So I have an order form with a list of SKUs. If you enter a quantity next to any SKU the form then the price and totals show up. If you don't choose any quantity for a given SKU then no price is calculated and nothing is added to the total.

So lets say there are 5 items on the form and 3 of them have been chosen.

SKU QTY PRICE EA. TOTAL
R43 3 $10 $30
R44
R76 7 $7 $49
S87
S38 2 $16 $32

I need to get the summary to only have 3 rows and drop the blank rows. And I don't mean to copy the rows, I mean to look at the table above and copy the content of a cell with a value and then move to the next cell with a value and copy that.

So it could look like

SKU
R43 3 $10 $30 in stock
R76 7 $7 $49 in stock
S38 2 $16 $32 no stock
Can this be done? I think this is like searching an array or something but I've no idea how to do it.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!