daddybirdian
New Member
- Joined
- Aug 21, 2007
- Messages
- 2
Here's my dilemna.
I've got 4000 lines of data, and it's broken down into 1000 or so groups (numbers of rows per group varies), and each group is separated by a blank row.
For instance:
Group A
Part Product Description Qty
ABC123 blah blah blah 2
ABC124 blah blah blah 1
ABC125 blah blah blah 2
Group A
Part Product Description Qty
ABC123 blah blah blah 2
ABC124 blah blah blah 1
ABC126 blah blah blah 2
ABC127 blah blah blah 2
ABC128 blah blah blah 2
ABC129 blah blah blah 2
I want to replace each row's part number with the group number found in the closest row above.
Does that make sense?
I've got 4000 lines of data, and it's broken down into 1000 or so groups (numbers of rows per group varies), and each group is separated by a blank row.
For instance:
Group A
Part Product Description Qty
ABC123 blah blah blah 2
ABC124 blah blah blah 1
ABC125 blah blah blah 2
Group A
Part Product Description Qty
ABC123 blah blah blah 2
ABC124 blah blah blah 1
ABC126 blah blah blah 2
ABC127 blah blah blah 2
ABC128 blah blah blah 2
ABC129 blah blah blah 2
I want to replace each row's part number with the group number found in the closest row above.
Does that make sense?