I'm wanting to copy data from a sheet with deleted columns (ie. goes straight from G to I, K to M etc.) When I copy the list of values I get blanks where those missing columns would have been, which I don't want. How do I get rid of them or prevent this happening? I'm using Excel 2010.

Thanks in advance, I'd really appreciate any help!