I have a simple table with three columns (B3:D30). The values in the cells in these columns are derived from formulae. I want to copy the resulting data from the populated cells into another three columns (say columns F, G and H) without copying the gaps. So the 27 rows in table B3:D30 will reduce (in this case) to data in cells F4:F7, G4:G7 and H4:H7. The actual columns in the table in my real spreadsheet are actually from B4:B200, and there will be lots of blanks that I want removed. In theory at least I might end up with a table which is just F4:H4, or it could be F4:H200 - either way, I want no gaps.
Any ideas? (I don't really want to use VBA. Is there a formula?)
I attach the sample data.