Hi,
I have a list of products produced by machines per day. each machine can produce multiple products and a product can be produced by multiple machines.
example:
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>I am trying for hours using Pivot table to create a "summary" table, something like this:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Thanks!
I have a list of products produced by machines per day. each machine can produce multiple products and a product can be produced by multiple machines.
example:
Date | Machine | Product |
4/2/2018 6:30 | 2 | A |
4/3/2018 6:30 | 2 | A |
4/4/2018 6:30 | 2 | A |
4/5/2018 6:30 | 2 | A |
4/8/2018 6:30 | 2 | A |
4/9/2018 6:30 | 2 | B |
4/10/2018 6:30 | 2 | B |
4/11/2018 6:30 | 2 | B |
4/12/2018 6:30 | 2 | B |
4/13/2018 6:30 | 2 | B |
4/14/2018 6:30 | 2 | B |
4/15/2018 6:30 | 2 | A |
4/16/2018 6:30 | 2 | A |
4/16/2018 16:48 | 2 | A |
4/17/2018 6:30 | 2 | A |
4/18/2018 6:30 | 2 | C |
4/19/2018 6:30 | 2 | C |
4/20/2018 6:30 | 2 | C |
4/2/2018 6:30 | 1 | D |
4/3/2018 6:30 | 1 | D |
4/4/2018 6:30 | 1 | D |
4/5/2018 6:30 | 1 | D |
4/8/2018 6:30 | 1 | D |
4/9/2018 6:30 | 1 | A |
4/10/2018 6:30 | 1 | A |
4/11/2018 6:30 | 1 | A |
4/12/2018 6:30 | 1 | A |
4/13/2018 6:30 | 1 | A |
4/14/2018 6:30 | 1 | A |
4/15/2018 6:30 | 1 | E |
4/16/2018 6:30 | 1 | E |
4/16/2018 16:48 | 1 | D |
4/17/2018 6:30 | 1 | D |
4/18/2018 6:30 | 1 | D |
4/19/2018 6:30 | 1 | D |
4/20/2018 6:30 | 1 | D |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
2 | Start | End |
A | 4/2/2018 6:30 | 4/8/2018 6:30 |
B | 4/9/2018 6:30 | 4/14/2018 6:30 |
A | 4/15/2018 6:30 | 4/17/2018 6:30 |
C | 4/18/2018 6:30 | 4/20/2018 6:30 |
1 | Start | End |
D | 4/2/2018 6:30 | 4/8/2018 6:30 |
A | 4/9/2018 6:30 | 4/14/2018 6:30 |
E | 4/15/2018 6:30 | 4/16/2018 6:30 |
D | 4/16/2018 16:48 | 4/20/2018 6:30 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Thanks!