Creating an X,Y scatter plot with columns sorted as (series name, x, y)

[turtlepower]

I am trying to create a x,y scatter plot of multiple series, each with their own x,y values. The data is organized as shown below, as (series name, x, y). I can create the scatter plot by adding each series to the chart, but there are hundreds of series and I need a faster way to go through it. Is there a way to input these three columns (or macros) so that excel can sort the data into series and graph it?

series	x	y
a1	599885.304	4051177.368
a1	599884.681	4051181.09
a1	599884.618	4051181.697
a2	599870.543	4051175.651
a3	599854	4051171.144
a3	599854.177	4051174.89
a4	599839.572	4051177.898

<tbody>
</tbody>

Thank you!

 

[turtlepower]

bump no response