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 .
