PLEASE HELP!!! Moving Data from one column to another while leaving other data behind.

No cell references given, just a list of names and dates.
So I must assume certain things.

The list is in column A, adjust this formula as necessary

=IFERROR(INDEX($A$1:$A$1000,AGGREGATE(15,6,ROW($A$1:$A$1000)/((ISNUMBER($A$1:$A$1000))),ROWS(A$1:A1))-(1-1),1),"")
copy down for each row you have in column A

This is a formula so if you want to copy the output elsewhere you will need to copy and paste VALUES

Oh I thought you wanted a list of dates withe the cities removed, ie a shorter list comprising only of dates.

You cant do what you want with formulas, youd have to use VBA.
Cells can contain either a value or a formula, not both.
You have values in column A so they must stay the same.

You could use a Helper column though like this.

in B1
=IF(ISTEXT(A1),A1,"")
in C1
=IF(ISNUMBER(A1),A1,"")

and copy down columns B and C.

This will produce the output you want in column B and C but column A will stay the same.

The only other way to go is use VBA to move the numbers into column B but I'm not an expert on VBA.

FYI
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.