Hi Guys,
I have data in the below format
| Product | Order Date | Ship Date |
| P1 | 01-Jan-20 | 04-Jan-20 |
| P2 | 02-Jan-20 | 05-Jan-20 |
| P3 | 06-Jan-20 | 06-Jan-20 |
and want to produce an excel output shown as below,
| | Ordered | Shipped |
| Product | 01-Jan-20 | 02-Jan-20 | 06-Jan-20 | 04-Jan-20 | 05-Jan-20 | 06-Jan-20 |
| P1 | 1 | | | 1 | | |
| P2 | | 1 | | | 1 | |
| P3 | | | 1 | | | 1 |
This looks simple, but I am not sure how to create the top sub header (ordered and shipped). Any help would be appreciated!
