Can Excel do a Segmentation?

[AK_Excel_13]

Does Excel (or Access) have the ablilty to join two tables in the manner that is presented in the image below?
Imgur: The most awesome images on the Internet

The Begin and End represents footage of a road. "ABC" & "XYZ" are different attribute types.
For example, if the Begin is 250 and the End is 400 then that segment of road is 150 feet long and has an attrbiute of B under "ABC" and has an attribute of Y under "XYZ" for the first 100 feet and an attribute of Z under "XYZ" for the other 50 feet.

I have the two input tables. I would like to know if there is an automatic way to create the output table as seen in the image.

Thank you.

 

[AK_Excel_13]

Here are the two inputs.

[TABLE="width: 336"]


<colgroup><col style="width: 48pt;" span="7" width="64">
<tbody>[TR]

[TD="width: 64, bgcolor: transparent"]Begin[/TD]

[TD="width: 64, bgcolor: transparent"]End[/TD]

[TD="width: 64, bgcolor: transparent"]ABC[/TD]

[TD="width: 64, bgcolor: transparent"][/TD]

[TD="width: 64, bgcolor: transparent"]Begin[/TD]

[TD="width: 64, bgcolor: transparent"]End[/TD]

[TD="width: 64, bgcolor: transparent"]XYZ[/TD]

[/TR]

[TR]

[TD="bgcolor: transparent, align: right"]0[/TD]

[TD="bgcolor: transparent, align: right"]150[/TD]

[TD="bgcolor: transparent"]B[/TD]

[TD="bgcolor: transparent"][/TD]

[TD="bgcolor: transparent, align: right"]0[/TD]

[TD="bgcolor: transparent, align: right"]100[/TD]

[TD="bgcolor: transparent"]Y[/TD]

[/TR]

[TR]

[TD="bgcolor: transparent, align: right"]150[/TD]

[TD="bgcolor: transparent, align: right"]250[/TD]

[TD="bgcolor: transparent"]C[/TD]

[TD="bgcolor: transparent"][/TD]

[TD="bgcolor: transparent, align: right"]100[/TD]

[TD="bgcolor: transparent, align: right"]200[/TD]

[TD="bgcolor: transparent"]X[/TD]

[/TR]

[TR]

[TD="bgcolor: transparent, align: right"]250[/TD]

[TD="bgcolor: transparent, align: right"]400[/TD]

[TD="bgcolor: transparent"]B[/TD]

[TD="bgcolor: transparent"][/TD]

[TD="bgcolor: transparent, align: right"]200[/TD]

[TD="bgcolor: transparent, align: right"]350[/TD]

[TD="bgcolor: transparent"]Y[/TD]

[/TR]

[TR]

[TD="bgcolor: transparent, align: right"]400[/TD]

[TD="bgcolor: transparent, align: right"]600[/TD]

[TD="bgcolor: transparent"]A[/TD]

[TD="bgcolor: transparent"][/TD]

[TD="bgcolor: transparent, align: right"]350[/TD]

[TD="bgcolor: transparent, align: right"]500[/TD]

[TD="bgcolor: transparent"]Z[/TD]

[/TR]

[TR]

[TD="bgcolor: transparent, align: right"]600[/TD]

[TD="bgcolor: transparent, align: right"]650[/TD]

[TD="bgcolor: transparent"]B[/TD]

[TD="bgcolor: transparent"][/TD]

[TD="bgcolor: transparent, align: right"]500[/TD]

[TD="bgcolor: transparent, align: right"]700[/TD]

[TD="bgcolor: transparent"]Y[/TD]

[/TR]

[TR]

[TD="bgcolor: transparent, align: right"]650[/TD]

[TD="bgcolor: transparent, align: right"]850[/TD]

[TD="bgcolor: transparent"]C[/TD]

[TD="bgcolor: transparent"][/TD]

[TD="bgcolor: transparent, align: right"]700[/TD]

[TD="bgcolor: transparent, align: right"]950[/TD]

[TD="bgcolor: transparent"]X[/TD]

[/TR]

[TR]

[TD="bgcolor: transparent, align: right"]850[/TD]

[TD="bgcolor: transparent, align: right"]1000[/TD]

[TD="bgcolor: transparent"]A[/TD]

[TD="bgcolor: transparent"][/TD]

[TD="bgcolor: transparent, align: right"]950[/TD]

[TD="bgcolor: transparent, align: right"]1000[/TD]

[TD="bgcolor: transparent"]Z[/TD]

[/TR]


</tbody>[/TABLE]