I have a table which houses transaction data moving a candidate through the recruitment process. The problem is I have one date column which houses all the transactions. So candidate 1 could be listed multiple times moving from different steps. I’m struggling to be able to do any kind of date difference between stages with the current data setup. Is there a way I could pivot/unpivot or manipulate the date in Power Query so I could easily do a date difference of the stages for candidates 1-4 as they pass through the recruitment cycle?
date column example.xlsx (8.9 KB)