If someone can help you will save my hand from carpal tunnel. I
imported some data from a warehouse program and it gives me item # and
all transactions associated.

blank row
Item # Invoice Date Remaing Items
BKD569 7685 5/5/98 500
6575 5/6/98 453
6756 5/7/98 412
5675 5/8/98 410
Blank row

I would like to be able to fill the item # in-front of all invoices
that correspond there is a blank line at the begining and end of the
invoices relating to a particular item.

If that can't be done, is there a way to move the item # to the last
invoice for the item and delete everything else above, for that item?
Thank you so much for any help!!!!!