Hi there,
New to VBA - have tried a few different bits of code but can't find one that achieves what I need.
Trying to transfer a 2-axis dataset into stacked columns, removing zero balances. I want to populate adjacent columns with the headers along each axis.
Below / linked image
is an example. Dataset is approx 7000 cells.

Any help would be fantastic.
Many thanks!
New to VBA - have tried a few different bits of code but can't find one that achieves what I need.
Trying to transfer a 2-axis dataset into stacked columns, removing zero balances. I want to populate adjacent columns with the headers along each axis.
Below / linked image

Any help would be fantastic.
Many thanks!