I have a list of items purchased, like below.
A | B | C | D | E |
id | item | qty | unit price | subtotal |
I'd like to have the column id to automatically increment correctly in each row where the subtotal is not null. How can I do it?