Graph values from 2d table where series switch places

[avensis1]

Hi

I have a problem that I'm not able to overcome. I have the data as shown below (dataset much larger, but follows the logic below).

- Cells A1:C1 are merged, so are D1:F1 and so on
- I want to show a graph with Months on the X-axis, and Market Share on the Y-axis, and then different lines for the different Companies (Comp A through Comp E)

I have tried to pull out the data with INDEX-MATCH to a separate sheet, where Comp A's market shares are shown on one row, and Comp B's market share in next row and so on, but I cannot get it working to find the corresponding month with the merged cells.

Any tips on how to do this?

Thanks!

	A	B	C	D	E	F	G	H	I
1	Jan	uary	2018	Feb	ruary	2018	Ma	rch	2018
2	Company Name	Value	Market Share	Company Name	Value	Market Share	Company Name	Value	Market Share
3	Comp A	100	0,29	Comp C	140	0,3	Comp E	75	0,16
4	Comp B	80	0,23	Comp A	105	0,23	Comp B	65	0,14
5	Comp C	75	0,22	Comp D	95	0,21	Comp A	60	0,13
6	Comp D	60	0,17	Comp B	80	0,17	Comp D	40	0,09
7	Comp E	30	0,09	Comp E	40	0,09	Comp C	10	0,02

<tbody>
</tbody>