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:

mgn	PPO	Prem	Eff
123	1	2	n/a
456	4	n/a	8

<tbody>
</tbody>

I want the output in another sheet to be:

mgn	metric	value
123	ppo	1
123	prem	2
456	ppo	4
456	eff	8

<tbody>
</tbody>

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