VBA, Macro, or formula to move data based off of value

I have a question that is hard to frame. I have some flight logbook data that I need consolidated on to a single line. The "SEQ NUMBER" column has a value of 1-5. If there are 3 flights with SEQ NUMBERS of 1,2,&3 they are all the same flight, but have different modes of flight. The only line I can keep is line one so I want to move values greater than zero from the lines below (2&3) for the different modes of flight, up to SEQ 1. I have attached a sample of data as an example. I either need to write a formula to accomplish this and then write VBA to delete the SEQ NUMBERS after one or a VBA module that will move the data to SEQ 1. If anyone has a reference or similar example I don't mind researching and finding a solution but I cannot find a starting point or the framework for the method to do it. Any suggestions would be appreciated.

Thanks for pointing out the obvious I should have thought of that. Below is a picture of what I am trying to do. The way the system logs the time is it splits one flight into three different legs if the mode of flight is different (Night, weather, etc). All three legs would equal the total of the flight. The system that I have to feed only accepts a single entry . I hope this helps. The bottom single line would be the end result in this example.
example.PNG

I am not good at this. Thanks for the patience. Flights with only one sequence number are good without any modifications. Flights with multiple sequence numbers are the same flight but the modes are broke out in separate lines (Night, Weather, etc.). I need to consolidate them back into 1 sequence number. When it is complete I want a list as below.
example2.PNG
I am currently doing this manually and then I have a vba module to save the results as a csv in a separate file. The modes of flight are highlighted in the attached screen shot. The columns in blue do not end up getting saved in the new csv. Just the columns with red headers. The new csv would look like the rows starting in row 22 of the screen shot with the headers as well. I hope this explains a little better and thanks for your reply and patience.

Thanks for your time! I will give that a shot and let you know how it works. Thanks again for the effort!

Keebellah,

That is absolutely perfect and I learned some valuable insight in looking at how you accomplished what I was trying to do. I can't thank you enough for your assistance and knowledge.

I'm working on optimizing so it doesn't take so long to run. When I run the code with 3400+ rows it takes about 20 minutes. The cells that are being copied are derived from formulas (the example just had values to make it easier). What would be your recommendation be to copy over just values to the new sheet (no formulas, formatting etc.). Thanks!

Thanks again. As expected it works exactly as I needed it to. I was close on the "xlpastevalues" but my inexperience surfaced and my syntax was incorrect. Thanks again