Reformat a list in a single column into multiple rows.

R

rjperket

New Member
Joined
Aug 16, 2010
Messages
20
What I want to do is to take a report (see below) that is generated by our system and convert it into a list that can be referenced by other worksheets and macros.

The report shows a list of orders (PO Number) in a shipment but rather than having each order on its individual row, each shipment is on a row with multiple order numbers in a single column.

So esentially I want to convert a list that looks like this:

<TABLE style="WIDTH: 164pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=219><COLGROUP><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1572" width=43><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547" width=97><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 32pt; HEIGHT: 12.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=17 width=43>Date</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 59pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=79>Shipment</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 73pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70 width=97>PO Number</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 height=17 align=right>4/1/12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73>1, 2, 3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2dddc; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 height=17 align=right>4/1/12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl88>4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 height=17 align=right>4/1/12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79>5, 6</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #e5e0ec; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl80 height=17 align=right>4/2/12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl81>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl82>7, 8, 9</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbeef3; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83 height=17 align=right>4/2/12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl84>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl85>10, 11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #fde9d9; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl86 height=17 align=right>4/2/12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl87>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl90>12</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 height=17 align=right>4/2/12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72>7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73>13, 14</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2dddc; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 height=17 align=right>4/3/12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75>8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76>15, 16, 17</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 height=17 align=right>4/3/12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl91>18</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #e5e0ec; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl80 height=17 align=right>4/3/12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl81>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl89>19</TD></TR></TBODY></TABLE>


Into something that looks like this:
<TABLE style="WIDTH: 164pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=219><COLGROUP><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1572" width=43><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547" width=97><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 32pt; HEIGHT: 12.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=17 width=43>
Date​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 59pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=79>
Shipment​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 73pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70 width=97>
PO Number​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 height=17 align=right>
4/1/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72>
1​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73>
1​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 height=17 align=right>
4/2/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72>
1​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73>
2​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 height=17 align=right>
4/3/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72>
1​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73>
3​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2dddc; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 height=17 align=right>
4/1/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75>
2​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76>
4​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 height=17 align=right>
4/1/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78>
3​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79>
5​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 height=17 align=right>
4/2/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78>
3​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79>
6​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #e5e0ec; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl80 height=17 align=right>
4/2/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl81>
4​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl82>
7​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #e5e0ec; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl80 height=17 align=right>
4/3/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl81>
4​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl82>
8​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #e5e0ec; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl80 height=17 align=right>
4/4/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl81>
4​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl82>
9​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbeef3; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83 height=17 align=right>
4/2/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl84>
5​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl85>
10​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbeef3; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83 height=17 align=right>
4/3/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl84>
5​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl85>
11​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #fde9d9; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl86 height=17 align=right>
4/2/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl87>
6​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl88>
12​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 height=17 align=right>
4/2/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72>
7​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73>
13​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 height=17 align=right>
4/3/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72>
7​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73>
14​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2dddc; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 height=17 align=right>
4/3/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75>
8​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76>
15​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2dddc; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 height=17 align=right>
4/4/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75>
8​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76>
16​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2dddc; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 height=17 align=right>
4/5/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75>
8​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76>
17​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 height=17 align=right>
4/3/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78>
9​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79>
18​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #e5e0ec; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl80 height=17 align=right>
4/3/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl81>
10​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl82>
19​
</TD></TR></TBODY></TABLE>


The interior color in the example is only to illustrate the change not really necessary in the actual process. The most important thing is that the list is converted with the corresponding data in the adjacent columns in the original rows. Those things are essential to making this useful.

I know how to get each of the number in the list elements in its own cell
for example:
<TABLE style="WIDTH: 265pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=353><COLGROUP><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1572" width=43><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" span=2 width=77><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 32pt; HEIGHT: 12.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=17 width=43>
Date​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 59pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=79>
Shipment​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 58pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70 width=77>
PO Number​
</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 58pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" width=77>
​
</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 58pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" width=77>
​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 height=17 align=right>
4/1/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72>
1​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73>
1​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73>
2​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73>
3​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2dddc; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 height=17 align=right>
4/1/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75>
2​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl88>
4​
</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8">
​
</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8">
​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 height=17 align=right>
4/1/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78>
3​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79>
5​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79>
6​
</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8">
​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #e5e0ec; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl80 height=17 align=right>
4/2/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl81>
4​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl82>
7​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl82>
8​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl82>
9​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbeef3; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83 height=17 align=right>
4/2/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl84>
5​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl85>
10​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl85>
11​
</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8">
​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #fde9d9; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl86 height=17 align=right>
4/2/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl87>
6​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #fde9d9; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl90>
12​
</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8">
​
</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8">
​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 height=17 align=right>
4/2/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72>
7​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73>
13​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73>
14​
</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8">
​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2dddc; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 height=17 align=right>
4/3/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75>
8​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76>
15​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76>
16​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76>
17​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 height=17 align=right>
4/3/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78>
9​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl91>
18​
</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8">
​
</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8">
​
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #e5e0ec; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl80 height=17 align=right>
4/3/12​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl81>
10​
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e5e0ec; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl89>
19​
</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8">
​
</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8"></TD></TR></TBODY></TABLE>

but I want to figure out how to transpose those rows into a single column.

Thanks in advance for any help on this!!!

Ryan

Here is my current macro and a truncated copy of the actual report to get an idea of what that looks like:
Code: 
Sub test()
Dim wksNew As Worksheet
Dim wksReport As Worksheet
Dim rngCol As Range
Dim rngRow As Range
Dim report As Name

Application.ScreenUpdating = False
Application.Calculation = xlManual
ActiveSheet.Name = "Report"
Columns("D:D").Select
    Selection.Cut
    'Create a new worksheet
Set wksNew = Worksheets.Add
    Range("A:A").Select
    ActiveSheet.Paste
    Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, textqualifier:=xlDoubleQuote, _
        consecutivedelimiter:=False, Tab:=False, semicolon:=False, Comma:=True, Space:=False, other:=False, _
            Fieldinfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), _
                Array(7, 1), Array(8, 1), Array(9, 1), Array(10, 1)), TrailingMinusNumbers:=True
    ActiveSheet.UsedRange.Select
    Selection.Cut
    Sheets("Report").Columns(4).Insert shift:=xlToRight
    'delete the new worksheet
    Application.DisplayAlerts = False
    wksNew.Delete
    With Application
        .DisplayAlerts = True
        .ScreenUpdating = False
        .Calculation = xlCalculationManual
    End With
    
End Sub
Code: 
<TABLE style="WIDTH: 1137pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1516><COLGROUP><COL style="WIDTH: 98pt; mso-width-source: userset; mso-width-alt: 4790" width=131><COL style="WIDTH: 98pt; mso-width-source: userset; mso-width-alt: 4754" width=130><COL style="WIDTH: 191pt; mso-width-source: userset; mso-width-alt: 9325" width=255><COL style="WIDTH: 498pt; mso-width-source: userset; mso-width-alt: 24283" width=664><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1280" width=35><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 2048" width=56><COL style="WIDTH: 125pt; mso-width-source: userset; mso-width-alt: 6107" width=167><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 98pt; HEIGHT: 12.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17 width=131>[FONT=Arial][SIZE=2]Target Delivery (Late)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 98pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=130>[FONT=Arial][SIZE=2]Primary Reference[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 191pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=255>[FONT=Arial][SIZE=2]Origin Name[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 498pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=664>[FONT=Arial][SIZE=2]PO Number[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 59pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=78>[FONT=Arial][SIZE=2]Pallet Count[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 26pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=35>[FONT=Arial][SIZE=2]Ctns[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 42pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=56>[FONT=Arial][SIZE=2]Quantity[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 125pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=167>[FONT=Arial][SIZE=2]Carrier Name[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 07:00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1643-1 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Two-One-Two New York Inc[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]77710, 77709, 79687, 79686, 79685, 79684, 79683, 78204, 78203[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]28[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]649[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]23280[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Bay & Bay Transfer CO Inc[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 07:01[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1605 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Fred David International USA Inc[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]77991, 78209, 78210, 78480, 81403, 78574, 78575, 81400, 77990, 78481[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]15[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]398[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]15208[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]J B Hunt Transport Inc[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 07:01[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1609 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]KBL Group Intl[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]77919, 78191, 78192, 78258, 78259, 78306, 78307, 78852, 78851[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]28[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]606[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]20114[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]J B Hunt Transport Inc[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 07:01[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1644 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Jordache c/o Command Logistics[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]77608, 77607[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]16[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]1599[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]13780[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]J B Hunt Transport Inc[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 07:01[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1648 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Janeric[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]79955, 77536, 77537, 77649, 77650, 77651, 77652, 79954, 80483[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]12[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]284[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]22685[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]J B Hunt Transport Inc[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 07:01[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1649 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]One World Apparel LLC c/o Unger Fabrik[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]77864, 77865, 81063, 81064, 81065, 81066[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]3[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]47[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]3301[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]J B Hunt Transport Inc[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 07:01[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1651 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]SRP APPAREL c/o Santa Fe Finishing[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]78863, 78864[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]4[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]195[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]6933[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]J B Hunt Transport Inc[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 09:30[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1693-1 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Mast Industries Inc[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]79408, 79407, 77647, 77648, 79316[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]26[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]691[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]34443[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Non Rev Domestic Carrier[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 11:31[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1679-1 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]GTHL Trading[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]77374, 77375, 78075, 78138, 77367[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]12[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]325[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]39061[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]J B Hunt Transport Inc[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 11:31[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1680-1 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Jiangsu Sainty Tech Co[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]77662, 77661, 77521, 77520, 77428, 77427, 77426, 77425, 78914, 78915, 78916, 78917, 78942, 78941[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]12[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]794[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]23116[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]J B Hunt Transport Inc[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 12:00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1641-1 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Jordache c/o Ditto Apparel[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]77357[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]1[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]37[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]400[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Con-way Freight 8Y[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 12:00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1657-1 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Fred David Intl USA Inc. C/O Deringer Inc.[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]81402, 81401[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]5[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]64[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]3434[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Con-way Freight 8Y[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 12:00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1691-1 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Erin London[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]79089, 79090, 79091, 79092[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]2[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]41[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]1800[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Con-way Freight 8Y[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 12:00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1664-1 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Bluprint Clothing Corp[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]81478[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]1[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]3[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]300[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Non Rev Domestic Carrier[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 12:00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1676-1 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Bonnie & Norma[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]78940, 78939[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]1[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]23[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]1350[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Non Rev Domestic Carrier[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 12:00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1689-1 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Tillsonsburg[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]78555, 78554[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]1[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]37[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]2806[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Non Rev Domestic Carrier[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 12:00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1677-1 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Tanya Creations Inc[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]79071[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]1[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]2[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]400[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Non Rev Domestic Carrier[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2]04/13/2012 12:00[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]CBOSL1678-1 (BOL)[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Amiee Lynn[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]78148, 78146[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]1[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]14[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>[FONT=Arial][SIZE=2]2755[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2]Non Rev Domestic Carrier[/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>[FONT=Arial][SIZE=2] [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2] [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2] [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>[FONT=Arial][SIZE=2]Total[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>[FONT=Arial][SIZE=2]169[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>[FONT=Arial][SIZE=2]5809[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>[FONT=Arial][SIZE=2]215166[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>[FONT=Arial][SIZE=2] [/SIZE][/FONT]</TD></TR></TBODY></TABLE>
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Sort by date Sort by votes
try something like this on the active sheet. Assumes first column is column A:
Code: 
Sub blah()
lr = Cells(Rows.Count, 1).End(xlUp).Row
For rw = lr To 2 Step -1
  xx = Split(Cells(rw, "D").Value, ",")
  If UBound(xx) > 0 Then
    Rows(rw + 1).Resize(UBound(xx)).Insert
    Cells(rw, "A").Resize(, 8).Copy Cells(rw + 1, "A").Resize(UBound(xx), 8)
    Cells(rw, "D").Resize(UBound(xx) + 1).Value = Application.Transpose(xx)
  End If
Next rw
End Sub
 
Upvote 0
p45cal said:
try something like this on the active sheet. Assumes first column is column A:
Code: 
Sub blah()
lr = Cells(Rows.Count, 1).End(xlUp).Row
For rw = lr To 2 Step -1
  xx = Split(Cells(rw, "D").Value, ",")
  If UBound(xx) > 0 Then
    Rows(rw + 1).Resize(UBound(xx)).Insert
    Cells(rw, "A").Resize(, 8).Copy Cells(rw + 1, "A").Resize(UBound(xx), 8)
    Cells(rw, "D").Resize(UBound(xx) + 1).Value = Application.Transpose(xx)
  End If
Next rw
End Sub
Click to expand...
Thanks for your reply.

That effectively transposes the list but I want the list of PO numbers to still be matched with the corresponding data in the columns next to them. Is there a way to insert the same number of rows as there are values in the PO number column?? So if there are 3 PO numbers it would count them and insert two additional rows after. Then I could simply have it fill the other values downward.
 
Upvote 0
rjperket said:
Is there a way to insert the same number of rows as there are values in the PO number column?? So if there are 3 PO numbers it would count them and insert two additional rows after.
Click to expand...
This already happens at the .Insert line.
rjperket said:
Then I could simply have it fill the other values downward.
Click to expand...
This already happens, but without actually having the data put into adjacent columns; it's done in memory instead.
The macro does what you asked right at the beginning, without your intermediate steps.
This:
Excel Workbook
ABCDEFGH
1Target Delivery (Late)Primary ReferenceOrigin NamePO NumberPallet CountCtnsQuantityCarrier Name
204/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc77710, 77709, 79687, 79686, 79685, 79684, 79683, 78204, 782032864923280Bay & Bay Transfer CO Inc
304/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc77991, 78209, 78210, 78480, 81403, 78574, 78575, 81400, 77990, 784811539815208J B Hunt Transport Inc
404/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl77919, 78191, 78192, 78258, 78259, 78306, 78307, 78852, 788512860620114J B Hunt Transport Inc
504/13/2012 07:01CBOSL1644 (BOL)Jordache c/o Command Logistics77608, 7760716159913780J B Hunt Transport Inc
604/13/2012 07:01CBOSL1648 (BOL)Janeric79955, 77536, 77537, 77649, 77650, 77651, 77652, 79954, 804831228422685J B Hunt Transport Inc
704/13/2012 07:01CBOSL1649 (BOL)One World Apparel LLC c/o Unger Fabrik77864, 77865, 81063, 81064, 81065, 810663473301J B Hunt Transport Inc
804/13/2012 07:01CBOSL1651 (BOL)SRP APPAREL c/o Santa Fe Finishing78863, 7886441956933J B Hunt Transport Inc
904/13/2012 09:30CBOSL1693-1 (BOL)Mast Industries Inc79408, 79407, 77647, 77648, 793162669134443Non Rev Domestic Carrier
1004/13/2012 11:31CBOSL1679-1 (BOL)GTHL Trading77374, 77375, 78075, 78138, 773671232539061J B Hunt Transport Inc
1104/13/2012 11:31CBOSL1680-1 (BOL)Jiangsu Sainty Tech Co77662, 77661, 77521, 77520, 77428, 77427, 77426, 77425, 78914, 78915, 78916, 78917, 78942, 789411279423116J B Hunt Transport Inc
1204/13/2012 12:00CBOSL1641-1 (BOL)Jordache c/o Ditto Apparel77357137400Con-way Freight 8Y
1304/13/2012 12:00CBOSL1657-1 (BOL)Fred David Intl USA Inc. C/O Deringer Inc.81402, 814015643434Con-way Freight 8Y
1404/13/2012 12:00CBOSL1691-1 (BOL)Erin London79089, 79090, 79091, 790922411800Con-way Freight 8Y
1504/13/2012 12:00CBOSL1664-1 (BOL)Bluprint Clothing Corp8147813300Non Rev Domestic Carrier
1604/13/2012 12:00CBOSL1676-1 (BOL)Bonnie & Norma78940, 789391231350Non Rev Domestic Carrier
1704/13/2012 12:00CBOSL1689-1 (BOL)Tillsonsburg78555, 785541372806Non Rev Domestic Carrier
1804/13/2012 12:00CBOSL1677-1 (BOL)Tanya Creations Inc7907112400Non Rev Domestic Carrier
1904/13/2012 12:00CBOSL1678-1 (BOL)Amiee Lynn78148, 781461142755Non Rev Domestic Carrier
Sheet


becomes this:
Excel Workbook
ABCDEFGH
1Target Delivery (Late)Primary ReferenceOrigin NamePO NumberPallet CountCtnsQuantityCarrier Name
204/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc777102864923280Bay & Bay Transfer CO Inc
304/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc777092864923280Bay & Bay Transfer CO Inc
404/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc796872864923280Bay & Bay Transfer CO Inc
504/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc796862864923280Bay & Bay Transfer CO Inc
604/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc796852864923280Bay & Bay Transfer CO Inc
704/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc796842864923280Bay & Bay Transfer CO Inc
804/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc796832864923280Bay & Bay Transfer CO Inc
904/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc782042864923280Bay & Bay Transfer CO Inc
1004/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc782032864923280Bay & Bay Transfer CO Inc
1104/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc779911539815208J B Hunt Transport Inc
1204/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc782091539815208J B Hunt Transport Inc
1304/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc782101539815208J B Hunt Transport Inc
1404/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc784801539815208J B Hunt Transport Inc
1504/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc814031539815208J B Hunt Transport Inc
1604/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc785741539815208J B Hunt Transport Inc
1704/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc785751539815208J B Hunt Transport Inc
1804/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc814001539815208J B Hunt Transport Inc
1904/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc779901539815208J B Hunt Transport Inc
2004/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc784811539815208J B Hunt Transport Inc
2104/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl779192860620114J B Hunt Transport Inc
2204/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl781912860620114J B Hunt Transport Inc
2304/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl781922860620114J B Hunt Transport Inc
2404/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl782582860620114J B Hunt Transport Inc
2504/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl782592860620114J B Hunt Transport Inc
2604/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl783062860620114J B Hunt Transport Inc
2704/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl783072860620114J B Hunt Transport Inc
2804/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl788522860620114J B Hunt Transport Inc
2904/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl788512860620114J B Hunt Transport Inc
3004/13/2012 07:01CBOSL1644 (BOL)Jordache c/o Command Logistics7760816159913780J B Hunt Transport Inc
3104/13/2012 07:01CBOSL1644 (BOL)Jordache c/o Command Logistics7760716159913780J B Hunt Transport Inc
3204/13/2012 07:01CBOSL1648 (BOL)Janeric799551228422685J B Hunt Transport Inc
3304/13/2012 07:01CBOSL1648 (BOL)Janeric775361228422685J B Hunt Transport Inc
3404/13/2012 07:01CBOSL1648 (BOL)Janeric775371228422685J B Hunt Transport Inc
3504/13/2012 07:01CBOSL1648 (BOL)Janeric776491228422685J B Hunt Transport Inc
3604/13/2012 07:01CBOSL1648 (BOL)Janeric776501228422685J B Hunt Transport Inc
3704/13/2012 07:01CBOSL1648 (BOL)Janeric776511228422685J B Hunt Transport Inc
3804/13/2012 07:01CBOSL1648 (BOL)Janeric776521228422685J B Hunt Transport Inc
3904/13/2012 07:01CBOSL1648 (BOL)Janeric799541228422685J B Hunt Transport Inc
4004/13/2012 07:01CBOSL1648 (BOL)Janeric804831228422685J B Hunt Transport Inc
4104/13/2012 07:01CBOSL1649 (BOL)One World Apparel LLC c/o Unger Fabrik778643473301J B Hunt Transport Inc
4204/13/2012 07:01CBOSL1649 (BOL)One World Apparel LLC c/o Unger Fabrik778653473301J B Hunt Transport Inc
4304/13/2012 07:01CBOSL1649 (BOL)One World Apparel LLC c/o Unger Fabrik810633473301J B Hunt Transport Inc
4404/13/2012 07:01CBOSL1649 (BOL)One World Apparel LLC c/o Unger Fabrik810643473301J B Hunt Transport Inc
4504/13/2012 07:01CBOSL1649 (BOL)One World Apparel LLC c/o Unger Fabrik810653473301J B Hunt Transport Inc
4604/13/2012 07:01CBOSL1649 (BOL)One World Apparel LLC c/o Unger Fabrik810663473301J B Hunt Transport Inc
4704/13/2012 07:01CBOSL1651 (BOL)SRP APPAREL c/o Santa Fe Finishing7886341956933J B Hunt Transport Inc
4804/13/2012 07:01CBOSL1651 (BOL)SRP APPAREL c/o Santa Fe Finishing7886441956933J B Hunt Transport Inc
4904/13/2012 09:30CBOSL1693-1 (BOL)Mast Industries Inc794082669134443Non Rev Domestic Carrier
5004/13/2012 09:30CBOSL1693-1 (BOL)Mast Industries Inc794072669134443Non Rev Domestic Carrier
5104/13/2012 09:30CBOSL1693-1 (BOL)Mast Industries Inc776472669134443Non Rev Domestic Carrier
5204/13/2012 09:30CBOSL1693-1 (BOL)Mast Industries Inc776482669134443Non Rev Domestic Carrier
5304/13/2012 09:30CBOSL1693-1 (BOL)Mast Industries Inc793162669134443Non Rev Domestic Carrier
5404/13/2012 11:31CBOSL1679-1 (BOL)GTHL Trading773741232539061J B Hunt Transport Inc
5504/13/2012 11:31CBOSL1679-1 (BOL)GTHL Trading773751232539061J B Hunt Transport Inc
5604/13/2012 11:31CBOSL1679-1 (BOL)GTHL Trading780751232539061J B Hunt Transport Inc
5704/13/2012 11:31CBOSL1679-1 (BOL)GTHL Trading781381232539061J B Hunt Transport Inc
5804/13/2012 11:31CBOSL1679-1 (BOL)GTHL Trading773671232539061J B Hunt Transport Inc
5904/13/2012 11:31CBOSL1680-1 (BOL)Jiangsu Sainty Tech Co776621279423116J B Hunt Transport Inc
6004/13/2012 11:31CBOSL1680-1 (BOL)Jiangsu Sainty Tech Co776611279423116J B Hunt Transport Inc
Sheet


Some rows missing from the bottom due to Excel Jeanie HTML4 restrictions
 
Last edited:
Upvote 0
I'm sorry! The first time I tested it I must have screwed something up because it only changed the single column with the PO numbers in it. I just tried it again and it worked perfectly. Thank you very much p45cal!

p45cal said:
This already happens at the .Insert line. This already happens, but without actually having the data put into adjacent columns; it's done in memory instead.
The macro does what you asked right at the beginning, without your intermediate steps.
This:
Excel Workbook
ABCDEFGH
1Target Delivery (Late)Primary ReferenceOrigin NamePO NumberPallet CountCtnsQuantityCarrier Name
204/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc77710, 77709, 79687, 79686, 79685, 79684, 79683, 78204, 782032864923280Bay & Bay Transfer CO Inc
304/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc77991, 78209, 78210, 78480, 81403, 78574, 78575, 81400, 77990, 784811539815208J B Hunt Transport Inc
404/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl77919, 78191, 78192, 78258, 78259, 78306, 78307, 78852, 788512860620114J B Hunt Transport Inc
504/13/2012 07:01CBOSL1644 (BOL)Jordache c/o Command Logistics77608, 7760716159913780J B Hunt Transport Inc
604/13/2012 07:01CBOSL1648 (BOL)Janeric79955, 77536, 77537, 77649, 77650, 77651, 77652, 79954, 804831228422685J B Hunt Transport Inc
704/13/2012 07:01CBOSL1649 (BOL)One World Apparel LLC c/o Unger Fabrik77864, 77865, 81063, 81064, 81065, 810663473301J B Hunt Transport Inc
804/13/2012 07:01CBOSL1651 (BOL)SRP APPAREL c/o Santa Fe Finishing78863, 7886441956933J B Hunt Transport Inc
904/13/2012 09:30CBOSL1693-1 (BOL)Mast Industries Inc79408, 79407, 77647, 77648, 793162669134443Non Rev Domestic Carrier
1004/13/2012 11:31CBOSL1679-1 (BOL)GTHL Trading77374, 77375, 78075, 78138, 773671232539061J B Hunt Transport Inc
1104/13/2012 11:31CBOSL1680-1 (BOL)Jiangsu Sainty Tech Co77662, 77661, 77521, 77520, 77428, 77427, 77426, 77425, 78914, 78915, 78916, 78917, 78942, 789411279423116J B Hunt Transport Inc
1204/13/2012 12:00CBOSL1641-1 (BOL)Jordache c/o Ditto Apparel77357137400Con-way Freight 8Y
1304/13/2012 12:00CBOSL1657-1 (BOL)Fred David Intl USA Inc. C/O Deringer Inc.81402, 814015643434Con-way Freight 8Y
1404/13/2012 12:00CBOSL1691-1 (BOL)Erin London79089, 79090, 79091, 790922411800Con-way Freight 8Y
1504/13/2012 12:00CBOSL1664-1 (BOL)Bluprint Clothing Corp8147813300Non Rev Domestic Carrier
1604/13/2012 12:00CBOSL1676-1 (BOL)Bonnie & Norma78940, 789391231350Non Rev Domestic Carrier
1704/13/2012 12:00CBOSL1689-1 (BOL)Tillsonsburg78555, 785541372806Non Rev Domestic Carrier
1804/13/2012 12:00CBOSL1677-1 (BOL)Tanya Creations Inc7907112400Non Rev Domestic Carrier
1904/13/2012 12:00CBOSL1678-1 (BOL)Amiee Lynn78148, 781461142755Non Rev Domestic Carrier
Sheet


becomes this:
Excel Workbook
ABCDEFGH
1Target Delivery (Late)Primary ReferenceOrigin NamePO NumberPallet CountCtnsQuantityCarrier Name
204/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc777102864923280Bay & Bay Transfer CO Inc
304/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc777092864923280Bay & Bay Transfer CO Inc
404/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc796872864923280Bay & Bay Transfer CO Inc
504/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc796862864923280Bay & Bay Transfer CO Inc
604/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc796852864923280Bay & Bay Transfer CO Inc
704/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc796842864923280Bay & Bay Transfer CO Inc
804/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc796832864923280Bay & Bay Transfer CO Inc
904/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc782042864923280Bay & Bay Transfer CO Inc
1004/13/2012 07:00CBOSL1643-1 (BOL)Two-One-Two New York Inc782032864923280Bay & Bay Transfer CO Inc
1104/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc779911539815208J B Hunt Transport Inc
1204/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc782091539815208J B Hunt Transport Inc
1304/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc782101539815208J B Hunt Transport Inc
1404/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc784801539815208J B Hunt Transport Inc
1504/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc814031539815208J B Hunt Transport Inc
1604/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc785741539815208J B Hunt Transport Inc
1704/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc785751539815208J B Hunt Transport Inc
1804/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc814001539815208J B Hunt Transport Inc
1904/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc779901539815208J B Hunt Transport Inc
2004/13/2012 07:01CBOSL1605 (BOL)Fred David International USA Inc784811539815208J B Hunt Transport Inc
2104/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl779192860620114J B Hunt Transport Inc
2204/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl781912860620114J B Hunt Transport Inc
2304/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl781922860620114J B Hunt Transport Inc
2404/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl782582860620114J B Hunt Transport Inc
2504/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl782592860620114J B Hunt Transport Inc
2604/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl783062860620114J B Hunt Transport Inc
2704/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl783072860620114J B Hunt Transport Inc
2804/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl788522860620114J B Hunt Transport Inc
2904/13/2012 07:01CBOSL1609 (BOL)KBL Group Intl788512860620114J B Hunt Transport Inc
3004/13/2012 07:01CBOSL1644 (BOL)Jordache c/o Command Logistics7760816159913780J B Hunt Transport Inc
3104/13/2012 07:01CBOSL1644 (BOL)Jordache c/o Command Logistics7760716159913780J B Hunt Transport Inc
3204/13/2012 07:01CBOSL1648 (BOL)Janeric799551228422685J B Hunt Transport Inc
3304/13/2012 07:01CBOSL1648 (BOL)Janeric775361228422685J B Hunt Transport Inc
3404/13/2012 07:01CBOSL1648 (BOL)Janeric775371228422685J B Hunt Transport Inc
3504/13/2012 07:01CBOSL1648 (BOL)Janeric776491228422685J B Hunt Transport Inc
3604/13/2012 07:01CBOSL1648 (BOL)Janeric776501228422685J B Hunt Transport Inc
3704/13/2012 07:01CBOSL1648 (BOL)Janeric776511228422685J B Hunt Transport Inc
3804/13/2012 07:01CBOSL1648 (BOL)Janeric776521228422685J B Hunt Transport Inc
3904/13/2012 07:01CBOSL1648 (BOL)Janeric799541228422685J B Hunt Transport Inc
4004/13/2012 07:01CBOSL1648 (BOL)Janeric804831228422685J B Hunt Transport Inc
4104/13/2012 07:01CBOSL1649 (BOL)One World Apparel LLC c/o Unger Fabrik778643473301J B Hunt Transport Inc
4204/13/2012 07:01CBOSL1649 (BOL)One World Apparel LLC c/o Unger Fabrik778653473301J B Hunt Transport Inc
4304/13/2012 07:01CBOSL1649 (BOL)One World Apparel LLC c/o Unger Fabrik810633473301J B Hunt Transport Inc
4404/13/2012 07:01CBOSL1649 (BOL)One World Apparel LLC c/o Unger Fabrik810643473301J B Hunt Transport Inc
4504/13/2012 07:01CBOSL1649 (BOL)One World Apparel LLC c/o Unger Fabrik810653473301J B Hunt Transport Inc
4604/13/2012 07:01CBOSL1649 (BOL)One World Apparel LLC c/o Unger Fabrik810663473301J B Hunt Transport Inc
4704/13/2012 07:01CBOSL1651 (BOL)SRP APPAREL c/o Santa Fe Finishing7886341956933J B Hunt Transport Inc
4804/13/2012 07:01CBOSL1651 (BOL)SRP APPAREL c/o Santa Fe Finishing7886441956933J B Hunt Transport Inc
4904/13/2012 09:30CBOSL1693-1 (BOL)Mast Industries Inc794082669134443Non Rev Domestic Carrier
5004/13/2012 09:30CBOSL1693-1 (BOL)Mast Industries Inc794072669134443Non Rev Domestic Carrier
5104/13/2012 09:30CBOSL1693-1 (BOL)Mast Industries Inc776472669134443Non Rev Domestic Carrier
5204/13/2012 09:30CBOSL1693-1 (BOL)Mast Industries Inc776482669134443Non Rev Domestic Carrier
5304/13/2012 09:30CBOSL1693-1 (BOL)Mast Industries Inc793162669134443Non Rev Domestic Carrier
5404/13/2012 11:31CBOSL1679-1 (BOL)GTHL Trading773741232539061J B Hunt Transport Inc
5504/13/2012 11:31CBOSL1679-1 (BOL)GTHL Trading773751232539061J B Hunt Transport Inc
5604/13/2012 11:31CBOSL1679-1 (BOL)GTHL Trading780751232539061J B Hunt Transport Inc
5704/13/2012 11:31CBOSL1679-1 (BOL)GTHL Trading781381232539061J B Hunt Transport Inc
5804/13/2012 11:31CBOSL1679-1 (BOL)GTHL Trading773671232539061J B Hunt Transport Inc
5904/13/2012 11:31CBOSL1680-1 (BOL)Jiangsu Sainty Tech Co776621279423116J B Hunt Transport Inc
6004/13/2012 11:31CBOSL1680-1 (BOL)Jiangsu Sainty Tech Co776611279423116J B Hunt Transport Inc
Sheet


Some rows missing from the bottom due to Excel Jeanie HTML4 restrictions
Click to expand...
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
537
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
E
  • Question Question
VBA code clean up
Replies
9
Views
482
mumps
mumps
E
  • Question Question
VBA for Web Scraping help
Replies
0
Views
902
epactheactor
E

Forum statistics

Threads
1,223,214
Messages
6,170,774
Members
452,353
Latest member
strainu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top