(Power?) pivot: filter or split comma separated data in one cell to multiple columns in (power?) pivot table (by measure?)

[ooptennoort]

Í'll try to explain with data table/power pivot. I want to split the intervals (without ", ") in the column SectionS (plural!) giving each interval it's own column (with corresponding section as name) into a (power) pivot table. I guess using DAX is the only way... but how? I'm no Ferrari

Data Table:

In	Out	SectionS
8	1	0-2, 2-4, 4-6, 6-8
0.1	4.9	0-2, 2-4, 4-6
116	117	116-118
34	34	34-36
32.3	32.3	32-34
5	13	4-6, 6-8, 8-10, 10-12, 12-14
55.31	10	10-12, 12-14, 14-16, 16-18, 18-20, 20-22, 22-24, 24-26, 26-28, 28-30, 30-32, 32-34, 34-36, 36-38, 38-40, 40-42, 42-44, 44-46, 46-48, 48-50, 50-52, 52-54, 54-56
10	55.31	10-12, 12-14, 14-16, 16-18, 18-20, 20-22, 22-24, 24-26, 26-28, 28-30, 30-32, 32-34, 34-36, 36-38, 38-40, 40-42, 42-44, 44-46, 46-48, 48-50, 50-52, 52-54, 54-56
55.31	11.31	10-12, 12-14, 14-16, 16-18, 18-20, 20-22, 22-24, 24-26, 26-28, 28-30, 30-32, 32-34, 34-36, 36-38, 38-40, 40-42, 42-44, 44-46, 46-48, 48-50, 50-52, 52-54, 54-56
11.31	55.31	10-12, 12-14, 14-16, 16-18, 18-20, 20-22, 22-24, 24-26, 26-28, 28-30, 30-32, 32-34, 34-36, 36-38, 38-40, 40-42, 42-44, 44-46, 46-48, 48-50, 50-52, 52-54, 54-56
7.1	7.1	6-8
7.1	0	0-2, 2-4, 4-6, 6-8
7.2	7.2	6-8
7.55	7.55	6-8
7	0	0-2, 2-4, 4-6, 6-8
10.3	10.3	10-12
0	0	0-2
5	5.1	4-6
5	5	4-6
5	5	4-6
5.1	5.1	4-6
6.7	6.7	6-8
8.5	8.5	8-10
9	29	8-10, 10-12, 12-14, 14-16, 16-18, 18-20, 20-22, 22-24, 24-26, 26-28, 28-30
9	9	8-10
9.5	9.5	8-10
9.8	9.8	8-10
8.8	0	0-2, 2-4, 4-6, 6-8, 8-10
11.5	0	0-2, 2-4, 4-6, 6-8, 8-10, 10-12
88	0	0-2, 2-4, 4-6, 6-8, 8-10, 10-12, 12-14, 14-16, 16-18, 18-20, 20-22, 22-24, 24-26, 26-28, 28-30, 30-32, 32-34, 34-36, 36-38, 38-40, 40-42, 42-44, 44-46, 46-48, 48-50, 50-52, 52-54, 54-56, 56-58, 58-60, 60-62, 62-64, 64-66, 66-68, 68-70, 70-72, 72-74, 74-76, 76-78, 78-80, 80-82, 82-84, 84-86, 86-88
144	0	0-2, 2-4, 4-6, 6-8, 8-10, 10-12, 12-14, 14-16, 16-18, 18-20, 20-22, 22-24, 24-26, 26-28, 28-30, 30-32, 32-34, 34-36, 36-38, 38-40, 40-42, 42-44, 44-46, 46-48, 48-50, 50-52, 52-54, 54-56, 56-58, 58-60, 60-62, 62-64, 64-66, 66-68, 68-70, 70-72, 72-74, 74-76, 76-78, 78-80, 80-82, 82-84, 84-86, 86-88, 88-90, 90-92, 92-94, 94-96, 96-98, 98-100, 100-102, 102-104, 104-106, 106-108, 108-110, 110-112, 112-114, 114-116, 116-118, 118-120, 120-122, 122-124, 124-126, 126-128, 128-130, 130-132, 132-134, 134-136, 136-138, 138-140, 140-142, 142-144
101	0	0-2, 2-4, 4-6, 6-8, 8-10, 10-12, 12-14, 14-16, 16-18, 18-20, 20-22, 22-24, 24-26, 26-28, 28-30, 30-32, 32-34, 34-36, 36-38, 38-40, 40-42, 42-44, 44-46, 46-48, 48-50, 50-52, 52-54, 54-56, 56-58, 58-60, 60-62, 62-64, 64-66, 66-68, 68-70, 70-72, 72-74, 74-76, 76-78, 78-80, 80-82, 82-84, 84-86, 86-88, 88-90, 90-92, 92-94, 94-96, 96-98, 98-100, 100-102
100.9999	0	0-2, 2-4, 4-6, 6-8, 8-10, 10-12, 12-14, 14-16, 16-18, 18-20, 20-22, 22-24, 24-26, 26-28, 28-30, 30-32, 32-34, 34-36, 36-38, 38-40, 40-42, 42-44, 44-46, 46-48, 48-50, 50-52, 52-54, 54-56, 56-58, 58-60, 60-62, 62-64, 64-66, 66-68, 68-70, 70-72, 72-74, 74-76, 76-78, 78-80, 80-82, 82-84, 84-86, 86-88, 88-90, 90-92, 92-94, 94-96, 96-98, 98-100, 100-102
100.000001	0	0-2, 2-4, 4-6, 6-8, 8-10, 10-12, 12-14, 14-16, 16-18, 18-20, 20-22, 22-24, 24-26, 26-28, 28-30, 30-32, 32-34, 34-36, 36-38, 38-40, 40-42, 42-44, 44-46, 46-48, 48-50, 50-52, 52-54, 54-56, 56-58, 58-60, 60-62, 62-64, 64-66, 66-68, 68-70, 70-72, 72-74, 74-76, 76-78, 78-80, 80-82, 82-84, 84-86, 86-88, 88-90, 90-92, 92-94, 94-96, 96-98, 98-100, 100-102
5.99	0	0-2, 2-4, 4-6
0.001	0	0-2
3.499999	0	0-2, 2-4
3.5000001	0	0-2, 2-4
0	5	0-2, 2-4, 4-6
6.5000001	0	0-2, 2-4, 4-6, 6-8
6.000001	0	0-2, 2-4, 4-6, 6-8
7.5000001	0	0-2, 2-4, 4-6, 6-8
7.00001	0	0-2, 2-4, 4-6, 6-8
7.9999999	0	0-2, 2-4, 4-6, 6-8
8.5000001	0	0-2, 2-4, 4-6, 6-8, 8-10
8.0000001	0	0-2, 2-4, 4-6, 6-8, 8-10
9.500001	0	0-2, 2-4, 4-6, 6-8, 8-10

What I would LIKE (example Table+Pivot):

Table
ID	In	Out	Sections
344	8	1	0-2, 2-4, 4-6, 6-8
345	0.1	4.9	0-2, 2-4, 4-6
346	116	117	116-118
347	34	34	34-36
348	32.3	32.3	32-34
349	5	13	4-6, 6-8, 8-10, 10-12, 12-14
350	21.3	25.9	20-22, 22-24, 24-26
Pivot
ID	0-2	2-4	4-6	6-8	8-10	10-12	12-14	20-22	22-24	24-26	32-34	34-36	116-118
344	1	1	1	1
345	1	1	1
346													1
347												1
348											1
349	1	1	1	1	1	1	1
350								1	1	1
Total	3	3	3	2	1	1	1	1	1	1	1	1	1

BUT what I now have (WRONG Pivot):

	Column Labels
	0-2	0-2, 2-4	0-2, 2-4, 4-6	0-2, 2-4, 4-6, 6-8	0-2, 2-4, 4-6, 6-8, 8-10	0-2, 2-4, 4-6, 6-8, 8-10, 10-12	0-2, 2-4, 4-6, 6-8, 8-10, 10-12, 12-14, 14-16, 16-18, 18-20, 20-22, 22-24, 24-26, 26-28, 28-30, 30-32, 32-34, 34-36, 36-38, 38-40, 40-42, 42-44, 44-46, 46-48, 48-50, 50-52, 52-54, 54-56, 56-58, 58-60, 60-62, 62-64, 64-66, 66-68, 68-70, 70-72, 72-74, 74-76, 76-78, 78-80, 80-82, 82-84, 84-86, 86-88	0-2, 2-4, 4-6, 6-8, 8-10, 10-12, 12-14, 14-16, 16-18, 18-20, 20-22, 22-24, 24-26, 26-28, 28-30, 30-32, 32-34, 34-36, 36-38, 38-40, 40-42, 42-44, 44-46, 46-48, 48-50, 50-52, 52-54, 54-56, 56-58, 58-60, 60-62, 62-64, 64-66, 66-68, 68-70, 70-72, 72-74, 74-76, 76-78, 78-80, 80-82, 82-84, 84-86, 86-88, 88-90, 90-92, 92-94, 94-96, 96-98, 98-100, 100-102	0-2, 2-4, 4-6, 6-8, 8-10, 10-12, 12-14, 14-16, 16-18, 18-20, 20-22, 22-24, 24-26, 26-28, 28-30, 30-32, 32-34, 34-36, 36-38, 38-40, 40-42, 42-44, 44-46, 46-48, 48-50, 50-52, 52-54, 54-56, 56-58, 58-60, 60-62, 62-64, 64-66, 66-68, 68-70, 70-72, 72-74, 74-76, 76-78, 78-80, 80-82, 82-84, 84-86, 86-88, 88-90, 90-92, 92-94, 94-96, 96-98, 98-100, 100-102, 102-104, 104-106, 106-108, 108-110, 110-112, 112-114, 114-116, 116-118, 118-120, 120-122, 122-124, 124-126, 126-128, 128-130, 130-132, 132-134, 134-136, 136-138, 138-140, 140-142, 142-144	10-12	10-12, 12-14, 14-16, 16-18, 18-20, 20-22, 22-24, 24-26, 26-28, 28-30, 30-32, 32-34, 34-36, 36-38, 38-40, 40-42, 42-44, 44-46, 46-48, 48-50, 50-52, 52-54, 54-56	116-118	32-34	34-36	4-6	4-6, 6-8, 8-10, 10-12, 12-14	6-8	8-10	8-10, 10-12, 12-14, 14-16, 16-18, 18-20, 20-22, 22-24, 24-26, 26-28, 28-30	Grand Total
Count of In	2	2	3	8	4	1	1	3	1	1	4	1	1	1	4	1	4	4	1	47