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:
[TABLE="width: 295"]
<tbody>[TR]
[TD]name
[/TD]
[TD]app1
[/TD]
[TD]app2
[/TD]
[TD]app3
[/TD]
[/TR]
[TR]
[TD]computer 1
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]
To this:
[TABLE="width: 167"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]App
[/TD]
[/TR]
[TR]
[TD]computer 1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]computer 1
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]computer 1
[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 295"]
<tbody>[TR]
[TD]name
[/TD]
[TD]app1
[/TD]
[TD]app2
[/TD]
[TD]app3
[/TD]
[/TR]
[TR]
[TD]computer 1
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]
To this:
[TABLE="width: 167"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]App
[/TD]
[/TR]
[TR]
[TD]computer 1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]computer 1
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]computer 1
[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]
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.