Text to Data or Columns

[Jhong]

I basically get my Data from external dashboard through Copy then paste matching source as Get data from Web function is not possible due to IE limitation. the Data however, when I paste to excel would only be on Column A, that is fine but I need to process it just like in my Example Column B onwards. Instead of using delimiter option redundantly I need a formula to get values as that of Row 2,3,5,9,10,13,14,17,18 of Column B onwards as sports available could vary to include any sport being played.

Thanks

	A	B	C	D	E	F	G	H
1	Section A <tbody> </tbody>	Section A <tbody> </tbody>	33 Events <tbody> </tbody>	Last updated at 16:52 <tbody> </tbody>
2	33 Events <tbody> </tbody>	Tennis	Football	Rugby union	Badminton	Basketball	Volleyball	and soon...
3	Tennis(23) - Football(4) - Rugby union(1) - Badminton(1) - Basketball(1) - Volleyball(3) <tbody> </tbody>	23	4	1	1	1	3
4	Last updated at 16:52 <tbody> </tbody>
5	Section B <tbody> </tbody>	Section B	0 Event <tbody> </tbody>	Last updated at 16:52 <tbody> </tbody>
6	0 Event <tbody> </tbody>
7	Last updated at 16:52 <tbody> </tbody>
8	Section C <tbody> </tbody>	Section C	33 Events <tbody> </tbody>	Last updated at 16:52
9	33 Events <tbody> </tbody>	Tennis	Football	Rugby union	Badminton	Basketball	Volleyball
10	Tennis(23) - Football(4) - Rugby union(1) - Badminton(1) - Basketball(1) - Volleyball(3) <tbody> </tbody>	23	4	1	1	1	3
11	Last updated at 16:52 <tbody> </tbody>
12	Section D <tbody> </tbody>	Section D	5 Events <tbody> </tbody>	Last updated at 16:52 <tbody> </tbody>
13	5 Events <tbody> </tbody>	Football	Rugby union	Basketball	Volleyball
14	Football(1) - Rugby union(1) - Basketball(1) - Volleyball(2) <tbody> </tbody>	1	1	1	2
15	Last updated at 16:52 <tbody> </tbody>
16	Section E <tbody> </tbody>	Section E	1 Event	Last updated at 16:52 <tbody> </tbody>
17	1 Event <tbody> </tbody>	Football
18	Football(1) <tbody> </tbody>	1
19	Last updated at 16:52 <tbody> </tbody>

<tbody>
</tbody>