Macro to Stack rows in columns- ignore certain values

[ahasija2s]

Hello everyone!
I am trying to write a macro which will stack data into multiple columns. For example, for this table:
[TABLE="width: 500"]
<tbody>[TR]
[TD]mgn[/TD]
[TD]PPO[/TD]
[TD]Prem[/TD]
[TD]Eff[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]n/a[/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]4[/TD]
[TD]n/a[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]
I want the output in another sheet to be:
[TABLE="width: 500"]
<tbody>[TR]
[TD]mgn[/TD]
[TD]metric[/TD]
[TD]value[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]ppo [/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]prem[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]ppo[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]eff[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]

So basically, everytime something is N/A, i want my macro to ignore it. Any and all help is appreciated! Thanks!

 

[ahasija2s]

Bump

 

[ahasija2s]

Please help