oh this is not clear....

Column 1 supposed to have date and time

Column 2 supposed to have number like 1000,2000, etc..

Column 3 will be the new column that I want to populate...