Forum Discussion
Combining rows and generating TimeSpan difference on date column
There are normally better or worse approaches depending on what you are trying to do. But that aside, you could do this in Power Query (get data).
Load the table
add an index column
create a custom column that is the index +1 (call it next)
save the query but don't load it
join the table to itself on the index = next column.
When done, delete all the columns you don't need, including the Index columns
There are normally better or worse approaches depending on what you are trying to do. But that aside, you could do this in Power Query (get data).
Load the table
add an index column
create a custom column that is the index +1 (call it next)
save the query but don't load it
join the table to itself on the index = next column.
When done, delete all the columns you don't need, including the Index columns