Thread: move values from top of column B to bottom of column A
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
bill k bill k is offline
external usenet poster
  
Posts: 8
Default move values from top of column B to bottom of column A
On Wednesday, 23 January 2019 04:22:55 UTC+13, wrote:
I want to find the next not empty cell in column B.
Cut the cell value.
Find the next not empty cell in column A.
Paste the cell value.

I hope there aren't thousands of numbers.
One way would be to select all the empty cells in column B
use the "delete cells" with the "shift cells up" option
after that you could select the cells, cut them and paste them to the list in column A
regards Bill K
Reply With QuoteReply With Quote