Hi folks, I wonder if anyone knows how I might create a report showing opportunity records by row and by column have one for each possible stage (kanban-style) and to show a value for the duration that the record spent in each stage, obviously with zeros for stages skipped along the way

I've only been able to find a solution that shows a row for each stage change and columns for from stage and to stage and duration, but that's different as opportunities may appear in multiple rows, one for each stage change and that's not what I'm looking for.

So just one row per opportunity and one column per stage, and the value in each being the duration of the record in each stage

thanks in advance if anyone has a solution!