I have a data table structure as seen below. This is booking data and each day is it’s own row in the datatable where the first row in each person group is the start date and time of the booking and the end date of the booking are on the last row in the group.
I need to transform it to the format below.
What would be the best way to do it. I’ve looked into dt.Select(), dt.AsEnumerable, but I haven’t had any look getting the desired end result.