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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Flight Number[/TD]
[TD]Airline[/TD]
[TD]Departure Airport[/TD]
[TD]Arrival Airport[/TD]
[TD]Arrival Time[/TD]
[TD]Days of Operation[/TD]
[/TR]
[TR]
[TD]AA123[/TD]
[TD]AA[/TD]
[TD]BOS[/TD]
[TD]LHR[/TD]
[TD]08:00[/TD]
[TD]123[/TD]
[/TR]
[TR]
[TD]AA123[/TD]
[TD]AA[/TD]
[TD]BOS[/TD]
[TD]LHR[/TD]
[TD]07:55[/TD]
[TD]1 456[/TD]
[/TR]
[TR]
[TD]AA123[/TD]
[TD]AA[/TD]
[TD]BOS[/TD]
[TD]LHR[/TD]
[TD]08:00[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]


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.