Hi All,
This is how my data is like . If you look at the data for the product Milk in Stage1 the date is 01-01-2021 and this product Milk moved to stage 2 on 23-02-2021 based on this we need to calculate the number of days a product took to travel from one stage to another .
Input DATA:
| Date |
Stage1 |
Stage2 |
Stage3 |
| 01-01-2021 |
Fruits |
Chocolate |
Rice |
| 23-01-2021 |
Milk |
Fruits |
Chocolate |
| 12-11-2021 |
Fish |
Milk |
Fruits |
Out Put Expectation : I want to use straight or pivot table to show which product took how many days in which stage just like below .
Please need help in resolving this .
| Product |
Stage1 |
Stage2 |
Stage3 |
| Milk |
323 |
|
|
| Chocolate |
|
22 |
|
| Fruits |
23 |
323 |
|
| Rice |
|
|
|
Thanks in Advance .
