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? Monica 104 Col A? Meredith 110 Col A? Brian 92 Col A? Madeline 112 Col A? Averie 140 Col A? ColB ColC ColD Monica Meredith Brian Madeline Averie Col A? ColB ColC ColD 104 110 92 112 140 Salary ColB ColC ColD 100 105 85 110 125 Salary% ColB ColC ColD 75.00% 71.00% 80.00% 81.00% 69.00% Bonus ColB ColC ColD 4 5 7 2 15 Bonus% ColB ColC ColD 10% 20% 10% 2% 14%
|
|---|