Need help with multiple IFs... or is there a better way?

Hello all!

I've been using this forum for couple months now and learned a lot from it [i had no idea about excel at first]... But I didn't find this specific topic... Hope I'm not double posting...

I have a data that i need to transfer to another sheet. The thing is that it has couple rows and columns and the goal is that there are no empty ones in between them when transferring. There is a conditional statement ">0" so if it's 0 skip to the next one.

How to continue from the one that was transferred? I was using IF since that was the one I know how to handle... Except that it's getting to a point where formula length is reaching Mars.

Any ideas?