I have table which consist of 12 columns and over 65000 rows. Except the first three columns, all date are numerical. The unwanted value in the data are blanks, 0 and 1, although I don't want to delete them.
At the moment all data are organised in ascending order based on the format of (dd/mm/yyyy hh:mm:ss). Without the unwanted values, I want to create a new column number each row sequentially by whole numbers instead of dates. As a result, I am hoping to plot a graph using the new column as the x-axis