-- removed inline image ---
<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore
adding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl63 {color:windowtext; font-size:10.0pt; font-weight:700; font-style:italic; text-decoration:underline; text-underline-style:single; font-family:Arial, sans-serif; mso-font-charset:0;} .xl64 {color:windowtext; font-size:10.0pt; font-weight:700; font-style:italic; text-decoration:underline; text-underline-style:single; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; border:.5pt solid windowtext;} .xl65 {color:windowtext; font-size:10.0pt; font-weight:700; font-style:italic; text-decoration:underline; text-underline-style:single; font-family:Arial, sans-serif; mso-font-charset:0; border:.5pt solid windowtext;} .xl66 {text-align:left; border:.5pt solid windowtext;} .xl67 {border:.5pt solid windowtext;} --> </style> <table style="border-collapse: collapse;width:221pt" border="0" cellpadding="0" cellspacing="0" width="221"> <colgroup><col style="mso-width-source:userset;mso-width-alt:3882;width:91pt" width="91"> <col style="width:65pt" span="2" width="65"> </colgroup><tbody><tr style="height:12.0pt" height="12"> <td class="xl64" style="height:12.0pt;width:91pt" height="12" width="91">vendor part # </td> <td class="xl64" style="border-left:none;width:65pt" width="65">mfg_part </td> <td class="xl65" style="border-left:none;width:65pt" width="65">Manufacturer</td> </tr> <tr style="height:15.0pt" height="15"> <td class="xl66" style="height:15.0pt;border-top:none" height="15">1</td> <td class="xl66" style="border-top:none;border-left:none">04-170 </td> <td class="xl67" style="border-top:none;border-left:none">OREGON </td> </tr> <tr style="height:15.0pt" height="15"> <td class="xl66" style="height:15.0pt;border-top:none" height="15">1</td> <td class="xl66" style="border-top:none;border-left:none">415-109 </td> <td class="xl67" style="border-top:none;border-left:none">STENS </td> </tr> <tr style="height:15.0pt" height="15"> <td class="xl66" style="height:15.0pt;border-top:none" height="15">1</td> <td class="xl66" style="border-top:none;border-left:none">B1SB1 </td> <td class="xl67" style="border-top:none;border-left:none">SUNBELT </td> </tr> </tbody></table>
I get information from my vendors in the format above, and need to have it in the format below.
-- removed inline image ---
<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl63 {border:.5pt solid windowtext;} --> </style> <table style="border-collapse: collapse;width:286pt" border="0" cellpadding="0" cellspacing="0" width="286"> <colgroup><col style="mso-width-source:userset;mso-width-alt:3882;width:91pt" width="91"> <col style="width:65pt" span="3" width="65"> </colgroup><tbody><tr style="height:15.0pt" height="15"> <td class="xl63" style="height:15.0pt;width:91pt" height="15" width="91">
</td> <td class="xl63" style="border-left:none;width:65pt" width="65">Manufacturer</td> <td class="xl63" style="border-left:none;width:65pt" width="65">
</td> <td class="xl63" style="border-left:none;width:65pt" width="65">
</td> </tr> <tr style="height:15.0pt" height="15"> <td class="xl63" style="height:15.0pt;border-top:none" height="15">Vendor part #</td> <td class="xl63" style="border-top:none;border-left:none">Oregon</td> <td class="xl63" style="border-top:none;border-left:none">Stens </td> <td class="xl63" style="border-top:none;border-left:none">Sunbelt</td> </tr> <tr style="height:15.0pt" height="15"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="15">1</td> <td class="xl63" style="border-top:none;border-left:none">04-170</td> <td class="xl63" style="border-top:none;border-left:none">415-109</td> <td class="xl63" style="border-top:none;border-left:none">B1SB1</td> </tr> </tbody></table>
I have tried using a pivot table, with little to no success. I can get the row labeled "vendor part #" and the columns with the manufacturer name,
but I cannot get the data to display properly. It tries to do a mathematical function as in add, subtract, etc. Is there a way I can get it to just populatethe data directly from the file without changing it.
I am using Microsoft Excel for Mac 2011. We do currently use navicat to do this kind of conversion but I thought it should be possible with excel. Any help would be greatly appreciated.
James
<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore
adding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl63 {color:windowtext; font-size:10.0pt; font-weight:700; font-style:italic; text-decoration:underline; text-underline-style:single; font-family:Arial, sans-serif; mso-font-charset:0;} .xl64 {color:windowtext; font-size:10.0pt; font-weight:700; font-style:italic; text-decoration:underline; text-underline-style:single; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; border:.5pt solid windowtext;} .xl65 {color:windowtext; font-size:10.0pt; font-weight:700; font-style:italic; text-decoration:underline; text-underline-style:single; font-family:Arial, sans-serif; mso-font-charset:0; border:.5pt solid windowtext;} .xl66 {text-align:left; border:.5pt solid windowtext;} .xl67 {border:.5pt solid windowtext;} --> </style> <table style="border-collapse: collapse;width:221pt" border="0" cellpadding="0" cellspacing="0" width="221"> <colgroup><col style="mso-width-source:userset;mso-width-alt:3882;width:91pt" width="91"> <col style="width:65pt" span="2" width="65"> </colgroup><tbody><tr style="height:12.0pt" height="12"> <td class="xl64" style="height:12.0pt;width:91pt" height="12" width="91">vendor part # </td> <td class="xl64" style="border-left:none;width:65pt" width="65">mfg_part </td> <td class="xl65" style="border-left:none;width:65pt" width="65">Manufacturer</td> </tr> <tr style="height:15.0pt" height="15"> <td class="xl66" style="height:15.0pt;border-top:none" height="15">1</td> <td class="xl66" style="border-top:none;border-left:none">04-170 </td> <td class="xl67" style="border-top:none;border-left:none">OREGON </td> </tr> <tr style="height:15.0pt" height="15"> <td class="xl66" style="height:15.0pt;border-top:none" height="15">1</td> <td class="xl66" style="border-top:none;border-left:none">415-109 </td> <td class="xl67" style="border-top:none;border-left:none">STENS </td> </tr> <tr style="height:15.0pt" height="15"> <td class="xl66" style="height:15.0pt;border-top:none" height="15">1</td> <td class="xl66" style="border-top:none;border-left:none">B1SB1 </td> <td class="xl67" style="border-top:none;border-left:none">SUNBELT </td> </tr> </tbody></table> I get information from my vendors in the format above, and need to have it in the format below.
-- removed inline image ---
<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore
adding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl63 {border:.5pt solid windowtext;} --> </style> <table style="border-collapse: collapse;width:286pt" border="0" cellpadding="0" cellspacing="0" width="286"> <colgroup><col style="mso-width-source:userset;mso-width-alt:3882;width:91pt" width="91"> <col style="width:65pt" span="3" width="65"> </colgroup><tbody><tr style="height:15.0pt" height="15"> <td class="xl63" style="height:15.0pt;width:91pt" height="15" width="91"> </td> <td class="xl63" style="border-left:none;width:65pt" width="65">Manufacturer</td> <td class="xl63" style="border-left:none;width:65pt" width="65">
</td> <td class="xl63" style="border-left:none;width:65pt" width="65">
</td> </tr> <tr style="height:15.0pt" height="15"> <td class="xl63" style="height:15.0pt;border-top:none" height="15">Vendor part #</td> <td class="xl63" style="border-top:none;border-left:none">Oregon</td> <td class="xl63" style="border-top:none;border-left:none">Stens </td> <td class="xl63" style="border-top:none;border-left:none">Sunbelt</td> </tr> <tr style="height:15.0pt" height="15"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="15">1</td> <td class="xl63" style="border-top:none;border-left:none">04-170</td> <td class="xl63" style="border-top:none;border-left:none">415-109</td> <td class="xl63" style="border-top:none;border-left:none">B1SB1</td> </tr> </tbody></table>
I have tried using a pivot table, with little to no success. I can get the row labeled "vendor part #" and the columns with the manufacturer name,
but I cannot get the data to display properly. It tries to do a mathematical function as in add, subtract, etc. Is there a way I can get it to just populatethe data directly from the file without changing it.
I am using Microsoft Excel for Mac 2011. We do currently use navicat to do this kind of conversion but I thought it should be possible with excel. Any help would be greatly appreciated.
James
