Need assistance with PowerQuery for course requests and teacher data

I am trying to assist several clients with PowerQuery. We need to get course request data for the upcoming school year in a csv file in the following format:
DistrictID, CampusID, Course_Code,CourseCode-CourseName,Next YR Grade, StateCrsID

We also need teacher data in a .csv as follows:
DistrictID,CampusID,PositionId, EmployeeID,LName,FName,Mname

If no position id is available, we can use the employee id again as a placeholder.

Any assistance will be greatly appreciated!