How to join an excel data table to a polyline shapefile (1:M)

Discussion created by lrandolph on Jul 16, 2012
Latest reply on Dec 10, 2013 by dlee-esristaff
I have a polyline shapefile that represents the spatial location of survey transects (broken into 168 segments) and an excel table of many butterfly observations that I would like to spatially display in ArcMap 10.  I made sure that the excel table and the shapefile both have a common text field (called T_S that represents the Transect and Segment numbers).  But when I join the excel table to the transect shapefile, I end up with the same 168 records, only two of which are populated with the data I want to map out.  I tried a relate function, but had the same result.

Any suggestions?  Any input is appreciated!