I will try to make this as clear as I can. It is quite a challenge and I
have no idea how to do it.

- Data is received from client, so I have to control over the content
- I need to quote on part numbers that may be supplied by multiple vendors
- IDEALLY the data is as follows:
Description Part Number Vendor Qty Price
Widgets 1111 ABC 500
.25
Widgets 2222 XYZ 500
.25
Widgets 3333 MMM 500
.25

However, often the data is received like this:
Description Part Number Vendor Qty Price
Widgets 1111 ABC 500
.25
2222 XYZ 500
.25
3333 MMM 500
.25

Code Required:
If there is a part number with no description to the left of it, copy the
description above so that it looks like scenario 1 above.

Thanks!




--
Thanks!

Dee