Could someone please help me with vba coding for the below excel query
raw data
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
Seeking the refine data as below
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks in advance!
raw data
name | score | name | score | name | score |
zen | 32 | men | 22 | ken | 58 |
ran | 45 | den | 23 | shen | 56 |
connor | 66 | junior | 24 | zenith | 25 |
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
Seeking the refine data as below
name | score |
zen | 32 |
ran | 45 |
connor | 66 |
name | score |
men | 22 |
den | 23 |
junior | 24 |
name | score |
ken | 58 |
shen | 56 |
zenith | 25 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks in advance!