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