In my attached example I want to cut contents of A3:A7 and paste it to the end of B1contents, in such a way that each cut/pasted cell "forces" a new line (Text Wrap). I think, but I'm not sure, that the cut/paste will always be to the cell immediately above and in the same column . . . not a different column.

I know Excel2007 is old & retired, but so am I. Any/all help will be greatly appreciated.