I was hoping someone could help me write or find a macro that would take two columns and move it to column A under the previous data and repeat for all columns. Basically user information is located in pairs of columns (typeofvalue, value). So column A and B are for user1, column C and D are user2, column E and F are user3, etc. Bonus if I could have a space in between each once moved.
Current:
<tbody>
</tbody>
Desired:
<tbody>
</tbody>
Each user has 47 rows of "values", for the example I just did two rows worth.
Current:
A | B | C | D |
User1First | User1Last | User2First | User2Last |
User1ValueTypeA1 | User1ValueB1 | User2ValueTypeA1 | User2ValueB1 |
User1ValueTypeA2 | User1ValueB2 | User2ValueTypeA1 | User2ValueB1 |
<tbody>
</tbody>
Desired:
A | B |
User1First | User1Last |
User1ValueTypeA1 | User1ValueB1 |
User1ValueTypeA2 | User1ValueB2 |
User2First | User2Last |
User2ValueTypeA1 | User2ValueB1 |
User2ValueTypeA1 | User2ValueB1 |
<tbody>
</tbody>
Each user has 47 rows of "values", for the example I just did two rows worth.
Last edited: