Import Excel data where not all the information is found in a single row or column
I am trying to import an ExceI data file that has the name in Row 1 but the actual data column headers start on Row 7 and data starts in Row 8 (please see attached file). I would like to have the imported data look like this: Name Date Flow-acft Concentration-ug/L (25) Load- metric tons (25)S382_P 06/18/2015 90.890579 93 ...