I have a row of 20 cells in Calc. (They happen to contain names and addresses.) I want to redistribute them into 3 columns so that I end up with 7 rows. Is there a straightforward way to do that?
7 * 3 = 21
May I assume you have 7 addresses, each one given in three adjacent cells?
You may start with this tutorial.