Ideally, after moving the data in A1's related cells, all of A1's
related cells should be in row 1.
Ideally, after moving the data in A7's related cells, all of A7's
related cells should be in row 7.

I do NOT want to clear the cells in rows 2 thru 6.
I want to find cells on these rows that contain data (so I can move
these cells, too).

Gary