如原始数据: A B …… 2008-10-2 14:44:22 2008-10-6 22:27:28 2008-10-7 21:02:25 2008-10-8 22:30:13 2008-10-10 15:43:47 2008-10-10 18:49:38 2008-10-10 19:57:44 2008-10-10 20:58:54 2008-10-11 15:21:02 2008-10-11 22:08:59 2008-10-15 7:15:05 2008-10-15 10:16:08 2008-10-16 16:19:20 …… 最后要得到: A B …… 2008-10-2 14:44:22 2008-10-3 2008-10-4 2008-10-5 2008-10-6 22:27:28 2008-10-7 21:02:25 2008-10-8 22:30:13 2008-10-9 2008-10-10 15:43:47 2008-10-10 18:49:38 2008-10-10 19:57:44 2008-10-10 20:58:54 2008-10-11 15:21:02 2008-10-11 22:08:59 2008-10-12 2008-10-13 2008-10-14 2008-10-15 7:15:05 2008-10-15 10:16:08 2008-10-16 16:19:20 …… 即把原A列中不连贯的地方自动插入日期补全。。手工操作量太大了,请问有自动处理的方法吗?
[求助]请问如何自动插入日期使上下连贯
|