Excel中的库存重建从唯一产品库存状态和时间戳列表中进行

id  status      date      time

a   received    01-Jan-14 04:00
a   available   05-Jan-14 05:00
a   returned    06-Jan-14 13:00
a   destroyed   07-Jan-14 12:00
b   received    10-Jan-14 14:00
b   available   11-Jan-14 08:00
b   returned    12-Jan-14 09:00
b   destroyed   13-Jan-14 07:00
c   received    02-Jan-14 05:00
c   available   03-Jan-14 07:00
c   returned    05-Jan-14 08:00
d   received    09-Jan-14 02:00
d   available   12-Jan-14 06:00
(etc)
id  status      date      time

a   received