I have two columns representing X and Y and empty space then more values for the second graph.

The X values are different, and I want to plot them in the correct place.

For example, let’s say we have (X, Y)

Q,

1, 10

2, 30

4, 45

(Empty)

1.3, 16

2.7, 39

5.9, 78

I want to plot two line graphs. 1, 10 should plot at 1, with a Y value of 10, and 4, 45 should plot at 4 (and not 3) with a value of 45. 1.3, 16 should plot at 1.3 (and not 1) with Y value of 16 as a second line to compare the two datasets

How do I do this?