如何填充根据不同值的多个列一列
我有一个Excel文件:
+----+------------+
| ID | Order date |
+----+------------+
| A | 1/1/2011 |
| A | 1/3/2012 |
| A | 1/8/2013 |
| A | 1/20/2014 |
| A | 1/23/2015 |
| B | 1/1/2011 |
| B | 1/20/2014 |
| B | 1/23/2015 |
+----+------------+
我想将它转换成一份报告,告诉我什么都几年没人购买的产品在以下格式:
+----+------------+-----------+------+------+------+-----+
| ID | Order date | 2011 2012 | 2013 | 2014 | 2015 | |
+----+------------+-----------+------+------+------+-----+
| A | 1/1/2011 | Yes | No | No | No | No |
| A | 1/3/2012 | No | Yes | No | No | No |
| A | 1/8/2013 | No | No | Yes | No | No |
| A | 1/20/2014 | No | No | No | Yes | No |
| A | 1/23/2015 | No | No | No | No | Yes |
| B | 1/1/2011 | Yes | No | No | No | No |
| B | 1/20/2014 | No | No | No | Yes | No |
| B | 1/23/2015 | No | No | No | No | Yes |
+----+------------+-----------+------+------+------+-----+
任何帮助非常感谢!谢谢!