in reply to Parsing horizontal table in Excel & loading it into a database

Need clarification: "Salary in columns B & C."

Why is the salary (which appears to be a single, 5 or 6 digit number, associated with each name) extended across two columns? Where do names go? Col A or Col B? Or do you mean the names go in B and the Salaries in C? In that case, what's in Col A?

Second clarification needed: your question indicates headers in both data sections, but since there are five names, then for the data in the second data section -- the one you say appears in "Col E through J" and should begin in row 6 -- there can be no headers OTHER THAN THE NAMES. Is this your intent?

HINT: you can use <table>, <tr>, and <td> markup to make your data render in a manner that provides a clear indication of your intent. See Markup in the Monastery ... and unless you're proficient with html markup, you should probably test your efforts in your scratchpad, rather than in a new note, and especially rather than by trying to update your existing post.

WAG: Are you trying to convey something like this?

Col A?Monica104
Col A?Meredith 110
Col A?Brian 92
Col A?Madeline 112
Col A?Averie 140
Col A?ColBColCColDMonicaMeredithBrianMadelineAverie
Col A?ColBColCColD10411092112140
SalaryColBColCColD10010585110125
Salary%ColBColCColD75.00%71.00%80.00%81.00%69.00%
 
BonusColBColCColD457215
Bonus%ColBColCColD10%20%10%2%14%
  • Comment on Re: Parsing horizontal table in Excel & loading it into a database