How to make a legend out of a column in a scatter chart?

[RickArnold]

I have some data that I would like to plot on a scatter chart. Below is a basic example of the data I am using. I would like to have the Group as the legend, Days from Start as my X-axis, and Distance as my Y-axis. I know that I can add each group separately and select the appropriate zones as my input from the Select Data Source, but I have several thousand rows of data. Does anyone know how I can do this more easily? I am hoping not to create a VBA script.

[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]Group
[/TD]
[TD]Days from Start
[/TD]
[TD]Distance
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]1.1
[/TD]
[TD]2.5
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]2.3
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]2.9
[/TD]
[TD]6.5
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD].9
[/TD]
[TD]2.6
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]1.6
[/TD]
[TD]4.5
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]2.5
[/TD]
[TD]2.3
[/TD]
[/TR]
</tbody>[/TABLE]

 

[RickArnold]

BTW, the table evidently leaves a blank whenever a zero is in a cell.