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.

Begin	End	ABC		Begin	End	XYZ
0	150	B		0	100	Y
150	250	C		100	200	X
250	400	B		200	350	Y
400	600	A		350	500	Z
600	650	B		500	700	Y
650	850	C		700	950	X
850	1000	A		950	1000	Z

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


</tbody>