Hello everyone... I've a problem to draw lines between two lines. It can be one, two or three lines between two lines depend on data list. Data value in column A connect to data value in column B by row. As example A1 connect to B1, A2 to B2, A3 to B3...
A1 B1
A2 B2
A3 B3
A4 -
A5 -
A6 B6
.
.
But got data in column B with no value. So I only know the start point which is in column A. Refer to data example, how to read the data list so that i can draw the lines (A4 and A5 to unknown point) but in between the two lines (A3 to B3 and A6 to B6)? Thank in advance.