Hi, in table 1 shows how the data is presented to me, whilst table 2 shows how I want to have the data. How can I do this? I don't know any VBA.
Thanks in advance for your help.
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
Thanks in advance for your help.
Table 1
Coln A | Coln B | Coln C | Coln D | Coln E | Coln F | Coln Z |
Mike | 100 | |||||
John | 50 | |||||
Bill | 70 |
<tbody>
</tbody>
Table 2
Coln A | Coln B |
Mike | 100 |
John | 50 |
Bill | 70 |
<tbody>
</tbody>