davidanaya11579
New Member
- Joined
- Dec 26, 2017
- Messages
- 11
I'm working on a report with thousands of entries. For some reason, the report only returns data in column C the first time a value appears in column B, for all subsequent entries of that value(B), Column C remains empty. I need to locate all duplicate values in column B, and copy the value of Column C into all subsequent entries.
Example of Raw Report:
<tbody>
</tbody><colgroup><col span="2"><col></colgroup>
Example of Raw Report:
LoadNum | Prim Load# | SSLine B/L |
237098864 | 237098864 | |
238921496 | 238921496 | 238921496WAW |
240817258 | 240817258 | 240817258NGB |
242967262 | 242967262 | MSCUJR543586 |
245434172 | 242967262 | |
242984183 | 242984183 | HLCUCHI171002103 |
242988571 | 242988571 | HLCUCHI171034120 |
242989105 | 242988571 | |
242989108 | 242988571 | |
<tbody>
</tbody><colgroup><col span="2"><col></colgroup>