Not sure if the title correctly identifies this but here is what I am looking to do. I have a very large dataset but need it in a different format.
I need to transform this:
<tbody>
</tbody>
To this:
<tbody>
</tbody> I have found VBA that takes the column and creates a new row but not one that copies the first column/row information.
I appreciate any help you can provide.
I need to transform this:
name | app1 | app2 | app3 |
computer 1 | 1 | 2 | 3 |
<tbody>
</tbody>
To this:
Name | App |
computer 1 | 1 |
computer 1 | 2 |
computer 1 | 3 |
<tbody>
</tbody>
I appreciate any help you can provide.