I have a problem that I do not know how to solve.

Facts:
I have data in a text file that I can easily import into excel. The problem
is manipulating the data after it is in excel. The data comes in in the
following format:
Column A Column B
Employee ID: 123456 Key Data
Employee Name Smith Key Data
Other info Other info
Other info Other info
Pay Info1 123,456 Key Data
Pay Info2 789,123 Key Data
Total Pay 1,234,567 Key Data
Other info Other info
Department Accounting Key Data
Other info Other info

There is a blank row and then the next record starts in the same format.
Some records contain the other info fields others do not. However, all
records contain the Key Data fields.

I want to take this info and get it into the following format:
Column A Column B Column C Column D Column E Column F
Employee ID Employee Name PayInfo1 Pay Info2 Total Pay Department

The I can sort by Department, sort from highest Total Pay to lowest etc.
Each month I will need to do this so some records may change others may not.
New records may be added or employees may change department.

Can I do what I want to do or do I need to programming help?