Excel scatter plot with multiple series from 1 table

Easier way, just add column headers A, B, C in D1:F1. In D2 enter this formula: =IF($A2=D$1,$C2,NA()) and fill it down and right as needed.

Select B1:B8, hold Ctrl while selecting D1:F8 so both areas are selected, and insert a scatter plot.