Good Morning All,
I could use some help brainstorming for a solution. I have a data export in an excel table from a flight log for about 15 years. I need some help figuring out a way to efficiently manipulate the data into something I can use in a logbook program.
The table below represents a portion of the data. Each sequence number (SEQ_NUM) of one represents a flight. Some flights have more than one sequence number indicating that more than one mode of flight was logged (ie day, night, flir, goggles, etc.) as indicated in the FS_ID column (Flight symbol). The table below is an example of the data. What I am attempting to do is combine all segments of a flight onto one line, so each flight is listed in its entirety with all modes on one line. It is proving difficult to explain but I am hoping this will spark some ideas. This is only a partial listing of the data. Each flight has a date column as well. Eventually the FS_ID column will not be used if I can figure out how to move the data to the other columns on a single line. Hopefully this will make sense to someone. Thanks in advance for your advice
<tbody>
</tbody>
<colgroup><col><col><col><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>
I could use some help brainstorming for a solution. I have a data export in an excel table from a flight log for about 15 years. I need some help figuring out a way to efficiently manipulate the data into something I can use in a logbook program.
The table below represents a portion of the data. Each sequence number (SEQ_NUM) of one represents a flight. Some flights have more than one sequence number indicating that more than one mode of flight was logged (ie day, night, flir, goggles, etc.) as indicated in the FS_ID column (Flight symbol). The table below is an example of the data. What I am attempting to do is combine all segments of a flight onto one line, so each flight is listed in its entirety with all modes on one line. It is proving difficult to explain but I am hoping this will spark some ideas. This is only a partial listing of the data. Each flight has a date column as well. Eventually the FS_ID column will not be used if I can figure out how to move the data to the other columns on a single line. Hopefully this will make sense to someone. Thanks in advance for your advice
| SEQ_NUM | CAPACITY | TIME_NIGHT | TIME_XC | TIME_IFR | TIME_HOOD | TIME_ACTUAL | TIME_USER1 | TIME_USER2 | FS_ID | DS_ID | HRS | SEAT |
| 1 | .5 | .8 | .3 | 1.0 | 1.0 |
<tbody>
</tbody>
| SEQ_NUM | CAPACITY | TIME_NIGHT | TIME_XC | TIME_IFR | TIME_HOOD | TIME_ACTUAL | TIME_USER1 | TIME_USER2 | FS_ID | DS_ID | HRS | SEAT |
| 1 | N | PI | 0.1 | B | ||||||||
| 2 | NS | PI | 1.5 | B | ||||||||
| 1 | N | PI | 0.1 | F | ||||||||
| 2 | NS | PI | 1.3 | F | ||||||||
| 1 | N | PI | 0.1 | F | ||||||||
| 2 | NS | PI | 1.9 | F | ||||||||
| 1 | N | PI | 0.1 | F | ||||||||
| 2 | NG | PI | 1.2 | F | ||||||||
| 1 | N | PI | 0.1 | F | ||||||||
| 2 | NS | PI | 1.2 | F | ||||||||
| 1 | D | PI | 1.4 | F | ||||||||
| 1 | D | PI | 1 | F | ||||||||
| 1 | NS | PI | 1 | F | ||||||||
| 2 | N | PI | 0.2 | F | ||||||||
| 3 | H | PI | 1 | F | ||||||||
| 4 | D | PI | 4.3 | F |
<colgroup><col><col><col><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>
