Okay,

I have discovered that I can use the Paste-Special Transpose feature
to change F1, F2, F3 ... into F1, G1, H1 ... however how can I loop
this function for each independent last name/first name combo? This
part is well out of my league. Any recommendations?