I need help! I need to combine each unique value in column A that has duplicate values into a new sheet, this value is duplicated, because every time the record in column A changes status, it creates a new row, with the new status and date of the change in column F, I need to combine all this data in a single row for each unique value, I have tried it but I don’t know if it is the best way and I have not been able to calculate the days between each status change in column F and neither I got him to order them from the oldest state to the newest.

I leave you an example of my sheet, with a single unique value and the code that I managed to run.

enter image description here

The results I try to get:

enter image description here