Help with extracting flight information in multiple rows into one.

[spinningwren]

Hello All,

I am trying to identify flight routes, times and number of operations per week. The data I have has been provided with numerous entries, some the same and some slightly differing, where the flight may take off slightly earlier on a Monday than on a Friday. The number of operations is supplied by days of the week where 1 is Monday, 2 is Tuesday etc etc.

Flight Number	Airline	Departure Airport	Arrival Airport	Arrival Time	Days of Operation
AA123	AA	BOS	LHR	08:00	123
AA123	AA	BOS	LHR	07:55	1 456
AA123	AA	BOS	LHR	08:00	7

<tbody>
</tbody>

I am not interested in flight times on each day, just getting the average time, so I can put it into a time frame and the number of services per week.

Does anyone know how I can do this easily please?

Thanks in advance,
SW

 

[platonic567]

I would suggest creating a pivot table with "Average of Arrival Time" as values.