Hi - I have numerous historic data files - all are date & time stamped in a single column. All data is at five minute intervals over a ten week period. The data is in contiguous rows - there are no gaps; but sporadically the data is not contiguous - individual or strings of time stamps are absent, and different files may have different gaps!
Please - is there a method whereby Excel can sort the data such that blank rows are inserted for the missing time stamps? - such would enable me to align all the files for rapid comparison. Thank you.
Please - is there a method whereby Excel can sort the data such that blank rows are inserted for the missing time stamps? - such would enable me to align all the files for rapid comparison. Thank you.