Recently downloaded a spreadsheet that contains street data for a city that I'm doing an analysis for. The goal is to export this table in ArcMap, where I will use the geometry column to convert the lat/long coordinates into lines. When the data is exported into ArcMap, all the cells are not successfully exported, except for the first three rows. My guess is that the 4th row surpasses the 255 character limit and then consequently interrupts the rest of the data from transferring over. Is there a way to solve this?
On another note, how do I display the first three rows that do show up as lines on the map? I did check out some tools that could display XY data as points (which isn't what I want to do) and XY data as lines (which seemingly limits a line to two sets of lat/long pairs). In the case for the first row, how do you create a line that has three sets of coordinate sets?