How can I plot multiple graphs from a name column (from Excel)

I want to plot multiple graphs from a 3-column spreadsheet from Excel.

Data is in this format:
   (name);           (x-value);     (y-value);
ab-1 (~ 15 rows);         x;             y;
ab-2 (~ 15 rows);         x;             y;
ab-3 (~ 15 rows);         x;             y;
bc-1 (~ 15 rows);         x;             y;
bc-2 (~ 15 rows);         x;             y;
bc-3 (~ 15 rows);         x;             y;
cd-1 (~ 15 rows);         x;             y;
cd-2 (~ 15 rows);         x;             y;
cd-3 (~ 15 rows);         x;             y;
...

In this example, ab-1 represents one series of values. Where there is 15 data values in this series, one value by row. I would like each plot to have three series, represented by ab-1, ab-2 and ab-3 (So ~ 45 points, this is variable). How can I create multiple 3-series plots in MATLAB, where data is discredited by text in one column?

Answer 1

[dpb]

Use readtable and then splitapply with the first column ID as grouping variable. I suggest turning it into categorical variable.