Hello everyone!
I am trying to write a macro which will stack data into multiple columns. For example, for this table:
<tbody>
</tbody>I want the output in another sheet to be:
<tbody>
</tbody>
So basically, everytime something is N/A, i want my macro to ignore it. Any and all help is appreciated! Thanks!
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>
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!