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.
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
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.