Macro to Stack rows in columns- ignore certain values

ahasija2s

New Member
Joined
Jul 15, 2019
Messages
5
Hello everyone!
I am trying to write a macro which will stack data into multiple columns. For example, for this table:
mgnPPOPremEff
12312n/a
4564n/a8

<tbody>
</tbody>
I want the output in another sheet to be:
mgnmetricvalue
123ppo 1
123prem2
456ppo4
456eff8

<tbody>
</tbody>

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

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Watch MrExcel Video

Forum statistics

Threads
1,099,122
Messages
5,466,814
Members
406,500
Latest member
Tknotmaxx

This Week's Hot Topics

Top