There are a few ways to work around that. Maybe the least complicated, which doesn't involve VBA, is to select your column range A:G while B, D, and F are hidden as you say. Next, try clicking on Edit > Go To, Special, select "Visible cells only" and click OK. Then copy that selection, and go to your destination range and paste. What should show up is the data in A, C, E, and G.
If this is a task you need to repeat often we could automate it, but to keep things simple, see if this method here does what you want first.