I have a data set that contains dates as separate records. I want them collapsed to one record with all the dates

[erieqlik]

I have a data set (table) with the following columns:

Story, backlog_date, approved_date, inprogress_date, completed_date

The way it is assembled it has repeated rows for each story, I want to collapse the data to just a single line. Not all stories have values for the dates, i.e. is its not completed then there will be no row with a completed date. Below is a example of the data (what I have and what I want). 

I want to have a table that resembles the Result. 

[erieqlik · Accepted solution]

ChatGPT said to do this, it seemed to work.

Collapsed:
Load
Story,
FirstSortedValue(backlog_date, backlog_date) as backlog_date,
FirstSortedValue(approved_date, approved_date) as approved_date,
FirstSortedValue(inprogress_date, inprogress_date) as inprogress_date,
FirstSortedValue(completed_date, completed_date) as completed_date
Resident starting_data_set
Group by Story;