Aggregate Report for large Dataset

I'd like to create an aggregate report that outlines each customer's airline history. I attached the original data set and the final version of the summarized report that I'd like to create.

Are there any formulas that I can use to create a spreadsheet that shows a summary of each person's airline history?

Thanks in advance.