Is there was way, using formulas, to essentially eliminate blank rows and keep the cells that contain values? A simple example of what I want is below. The left two columns is the data that is currently spread out, and the two column on the right is what I want to achieve.
<tbody>
</tbody>
I've done this with a macro at one point but I was looking for a way to do it with just a formula. The cell values are being read in from a large set of data that can change
| A | B | A | B |
| C | D | ||
| C | D | E | F |
| E | F |
<tbody>
</tbody>
I've done this with a macro at one point but I was looking for a way to do it with just a formula. The cell values are being read in from a large set of data that can change
