Row heights do not adjust correctly after sorting

Hi there

I have a sheet with rows of various different heights. If I sort the data by a particular column (obviously causing the rows to re-order) the row heights do not "move" with the data. So for example, the height of row 5 stays the same, even after I have changed the order of the rows.

Is there a way to make the row height "move", so that if row 1 becomes row 5, the height of row 5 adjusts to the previous height of row 1.

Apologies if I have not been very clear. I hope someone can help.

Many thanks

Rob