Is this on once or permanent? When former, then Copy and PasteSpecial>Transpose (into location not intersecting with old data).

Having blank rows in tables is BAD (and EVIL)!