Hello,

On one hand I have a file with adjacent values in hexadecimal (from 000 to 0FF). For each of the values I have several columns describing the hexadecimal value.

On the other hand I have a second file with non adjacent hexadecimal values (000-001, 00A to 00E, etc....) that should match the ones of my first file. Each value has also several description columns. But this time it is not adjacent.

In fact the hexadecimal column is the link between the 2 files.
Unfortunately one of the file has gaps.....so I can't simply paste in order to compare....

I am searching for a way to fill in the gaps in my second file.
Something that would add what is here in bold:
000-001, 002-009, 001-00E, etc...)

Thanks in advance for your help,

Rob

Example: there is a gap between 40 and 43
Robert 003F
Philippe 0040
Luc 0043
tina 0044

What I would like : gap is filled in by 0
Robert 003F
Philippe 0040
0 0041
0 0042
Luc 0043
tina 0044