Email_address,First_name,Last_name
avance@duneland.k12.in.us,Abigail,Vance
astafford@duneland.k12.in.us,Adrienne,Stafford
AFath@duneland.k12.in.us,Alysha,Fath
ahicks@duneland.k12.in.us,Amanda,Hicks
...

person_id,person_number,first_name,middle_name,last_name,email_address,sis_username,location_id
AMLING-AMLINSUZ000,AMLINSUZ000,SUZANNE,R,AMLING,SUZANNE.AMLING@DUNELAND.K12.IN.US,samling,310
ARIZZI-ARIZZVIN000,ARIZZVIN000,VINCENT,ARTHUR,ARIZZI,VINCENT.ARIZZI@DUNELAND.K12.IN.US,varizzi,310
BIANCARDI-BIANCTON002,BIANCTON002,TONI,,BIANCARDI,toni.biancardi@duneland.k12.in.us,tbiancardi,310
BOY-BOY  JOD000,BOY  JOD000,JODIE,,BOY,jodie.boy@duneland.k12.in.us,jboy,310
BULLOCK-BULLOCHR000,BULLOCHR000,CHRISTINE,MAE,BULLOCK,CHRISTINE.BULLOCK@DUNELAND.K12.IN.US,cbullock

require 'CSV'

hs = %w{ First_name Last_name email_address person_id person_number sis_username location_id }

CSV.open('skyward.csv', "wb") do |csv|
  csv << hs
  CSV.foreach('asm.csv', headers: true) do { |row| << row.values_at(*hs) }
  CSV.foreach('google.csv', headers: true) do { |row| << row.values_at(*hs) }
end