I have a huge amount of data which I wish to convert into a different orientation (transpose) and delete zero values. Is there a way I can program excel to do it automatically. I have hopefully attched a simplified version showing what I am trying to do as i am finding it hard to explain.
Any help would be greatly appreciated.
Bookmarks