Reformat a list in a single column into multiple rows.

rjperket · Apr 12, 2012

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></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></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></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></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>

p45cal · Apr 12, 2012

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

rjperket · Apr 13, 2012

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

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.

p45cal · Apr 13, 2012

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.

This already happens at the .Insert line.

rjperket said:
Then I could simply have it fill the other values downward.

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

A

B

C

D

E

F

G

H

1

Target Delivery (Late)

Primary Reference

Origin Name

PO Number

Pallet Count

Ctns

Quantity

Carrier Name

2

04/13/2012 07:00

CBOSL1643-1 (BOL)

Two-One-Two New York Inc

77710, 77709, 79687, 79686, 79685, 79684, 79683, 78204, 78203

28

649

23280

Bay & Bay Transfer CO Inc

3

04/13/2012 07:01

CBOSL1605 (BOL)

Fred David International USA Inc

77991, 78209, 78210, 78480, 81403, 78574, 78575, 81400, 77990, 78481

15

398

15208

J B Hunt Transport Inc

4

04/13/2012 07:01

CBOSL1609 (BOL)

KBL Group Intl

77919, 78191, 78192, 78258, 78259, 78306, 78307, 78852, 78851

28

606

20114

J B Hunt Transport Inc

5

04/13/2012 07:01

CBOSL1644 (BOL)

Jordache c/o Command Logistics

77608, 77607

16

1599

13780

J B Hunt Transport Inc

6

04/13/2012 07:01

CBOSL1648 (BOL)

Janeric

79955, 77536, 77537, 77649, 77650, 77651, 77652, 79954, 80483

12

284

22685

J B Hunt Transport Inc

7

04/13/2012 07:01

CBOSL1649 (BOL)

One World Apparel LLC c/o Unger Fabrik

77864, 77865, 81063, 81064, 81065, 81066

3

47

3301

J B Hunt Transport Inc

8

04/13/2012 07:01

CBOSL1651 (BOL)

SRP APPAREL c/o Santa Fe Finishing

78863, 78864

4

195

6933

J B Hunt Transport Inc

9

04/13/2012 09:30

CBOSL1693-1 (BOL)

Mast Industries Inc

79408, 79407, 77647, 77648, 79316

26

691

34443

Non Rev Domestic Carrier

10

04/13/2012 11:31

CBOSL1679-1 (BOL)

GTHL Trading

77374, 77375, 78075, 78138, 77367

12

325

39061

J B Hunt Transport Inc

11

04/13/2012 11:31

CBOSL1680-1 (BOL)

Jiangsu Sainty Tech Co

77662, 77661, 77521, 77520, 77428, 77427, 77426, 77425, 78914, 78915, 78916, 78917, 78942, 78941

12

794

23116

J B Hunt Transport Inc

12

04/13/2012 12:00

CBOSL1641-1 (BOL)

Jordache c/o Ditto Apparel

77357

1

37

400

Con-way Freight 8Y

13

04/13/2012 12:00

CBOSL1657-1 (BOL)

Fred David Intl USA Inc. C/O Deringer Inc.

81402, 81401

5

64

3434

Con-way Freight 8Y

14

04/13/2012 12:00

CBOSL1691-1 (BOL)

Erin London

79089, 79090, 79091, 79092

2

41

1800

Con-way Freight 8Y

15

04/13/2012 12:00

CBOSL1664-1 (BOL)

Bluprint Clothing Corp

81478

1

3

300

Non Rev Domestic Carrier

16

04/13/2012 12:00

CBOSL1676-1 (BOL)

Bonnie & Norma

78940, 78939

1

23

1350

Non Rev Domestic Carrier

17

04/13/2012 12:00

CBOSL1689-1 (BOL)

Tillsonsburg

78555, 78554

1

37

2806

Non Rev Domestic Carrier

18

04/13/2012 12:00

CBOSL1677-1 (BOL)

Tanya Creations Inc

79071

1

2

400

Non Rev Domestic Carrier

19

04/13/2012 12:00

CBOSL1678-1 (BOL)

Amiee Lynn

78148, 78146

1

14

2755

Non Rev Domestic Carrier

Sheet

becomes this:

Excel Workbook

A

B

C

D

E

F

G

H

1

Target Delivery (Late)

Primary Reference

Origin Name

PO Number

Pallet Count

Ctns

Quantity

Carrier Name

2

04/13/2012 07:00

CBOSL1643-1 (BOL)

Two-One-Two New York Inc

77710

28

649

23280

Bay & Bay Transfer CO Inc

3

04/13/2012 07:00

CBOSL1643-1 (BOL)

Two-One-Two New York Inc

77709

28

649

23280

Bay & Bay Transfer CO Inc

4

04/13/2012 07:00

CBOSL1643-1 (BOL)

Two-One-Two New York Inc

79687

28

649

23280

Bay & Bay Transfer CO Inc

5

04/13/2012 07:00

CBOSL1643-1 (BOL)

Two-One-Two New York Inc

79686

28

649

23280

Bay & Bay Transfer CO Inc

6

04/13/2012 07:00

CBOSL1643-1 (BOL)

Two-One-Two New York Inc

79685

28

649

23280

Bay & Bay Transfer CO Inc

7

04/13/2012 07:00

CBOSL1643-1 (BOL)

Two-One-Two New York Inc

79684

28

649

23280

Bay & Bay Transfer CO Inc

8

04/13/2012 07:00

CBOSL1643-1 (BOL)

Two-One-Two New York Inc

79683

28

649

23280

Bay & Bay Transfer CO Inc

9

04/13/2012 07:00

CBOSL1643-1 (BOL)

Two-One-Two New York Inc

78204

28

649

23280

Bay & Bay Transfer CO Inc

10

04/13/2012 07:00

CBOSL1643-1 (BOL)

Two-One-Two New York Inc

78203

28

649

23280

Bay & Bay Transfer CO Inc

11

04/13/2012 07:01

CBOSL1605 (BOL)

Fred David International USA Inc

77991

15

398

15208

J B Hunt Transport Inc

12

04/13/2012 07:01

CBOSL1605 (BOL)

Fred David International USA Inc

78209

15

398

15208

J B Hunt Transport Inc

13

04/13/2012 07:01

CBOSL1605 (BOL)

Fred David International USA Inc

78210

15

398

15208

J B Hunt Transport Inc

14

04/13/2012 07:01

CBOSL1605 (BOL)

Fred David International USA Inc

78480

15

398

15208

J B Hunt Transport Inc

15

04/13/2012 07:01

CBOSL1605 (BOL)

Fred David International USA Inc

81403

15

398

15208

J B Hunt Transport Inc

16

04/13/2012 07:01

CBOSL1605 (BOL)

Fred David International USA Inc

78574

15

398

15208

J B Hunt Transport Inc

17

04/13/2012 07:01

CBOSL1605 (BOL)

Fred David International USA Inc

78575

15

398

15208

J B Hunt Transport Inc

18

04/13/2012 07:01

CBOSL1605 (BOL)

Fred David International USA Inc

81400

15

398

15208

J B Hunt Transport Inc

19

04/13/2012 07:01

CBOSL1605 (BOL)

Fred David International USA Inc

77990

15

398

15208

J B Hunt Transport Inc

20

04/13/2012 07:01

CBOSL1605 (BOL)

Fred David International USA Inc

78481

15

398

15208

J B Hunt Transport Inc

21

04/13/2012 07:01

CBOSL1609 (BOL)

KBL Group Intl

77919

28

606

20114

J B Hunt Transport Inc

22

04/13/2012 07:01

CBOSL1609 (BOL)

KBL Group Intl

78191

28

606

20114

J B Hunt Transport Inc

23

04/13/2012 07:01

CBOSL1609 (BOL)

KBL Group Intl

78192

28

606

20114

J B Hunt Transport Inc

24

04/13/2012 07:01

CBOSL1609 (BOL)

KBL Group Intl

78258

28

606

20114

J B Hunt Transport Inc

25

04/13/2012 07:01

CBOSL1609 (BOL)

KBL Group Intl

78259

28

606

20114

J B Hunt Transport Inc

26

04/13/2012 07:01

CBOSL1609 (BOL)

KBL Group Intl

78306

28

606

20114

J B Hunt Transport Inc

27

04/13/2012 07:01

CBOSL1609 (BOL)

KBL Group Intl

78307

28

606

20114

J B Hunt Transport Inc

28

04/13/2012 07:01

CBOSL1609 (BOL)

KBL Group Intl

78852

28

606

20114

J B Hunt Transport Inc

29

04/13/2012 07:01

CBOSL1609 (BOL)

KBL Group Intl

78851

28

606

20114

J B Hunt Transport Inc

30

04/13/2012 07:01

CBOSL1644 (BOL)

Jordache c/o Command Logistics

77608

16

1599

13780

J B Hunt Transport Inc

31

04/13/2012 07:01

CBOSL1644 (BOL)

Jordache c/o Command Logistics

77607

16

1599

13780

J B Hunt Transport Inc

32

04/13/2012 07:01

CBOSL1648 (BOL)

Janeric

79955

12

284

22685

J B Hunt Transport Inc

33

04/13/2012 07:01

CBOSL1648 (BOL)

Janeric

77536

12

284

22685

J B Hunt Transport Inc

34

04/13/2012 07:01

CBOSL1648 (BOL)

Janeric

77537

12

284

22685

J B Hunt Transport Inc

35

04/13/2012 07:01

CBOSL1648 (BOL)

Janeric

77649

12

284

22685

J B Hunt Transport Inc

36

04/13/2012 07:01

CBOSL1648 (BOL)

Janeric

77650

12

284

22685

J B Hunt Transport Inc

37

04/13/2012 07:01

CBOSL1648 (BOL)

Janeric

77651

12

284

22685

J B Hunt Transport Inc

38

04/13/2012 07:01

CBOSL1648 (BOL)

Janeric

77652

12

284

22685

J B Hunt Transport Inc

39

04/13/2012 07:01

CBOSL1648 (BOL)

Janeric

79954

12

284

22685

J B Hunt Transport Inc

40

04/13/2012 07:01

CBOSL1648 (BOL)

Janeric

80483

12

284

22685

J B Hunt Transport Inc

41

04/13/2012 07:01

CBOSL1649 (BOL)

One World Apparel LLC c/o Unger Fabrik

77864

3

47

3301

J B Hunt Transport Inc

42

04/13/2012 07:01

CBOSL1649 (BOL)

One World Apparel LLC c/o Unger Fabrik

77865

3

47

3301

J B Hunt Transport Inc

43

04/13/2012 07:01

CBOSL1649 (BOL)

One World Apparel LLC c/o Unger Fabrik

81063

3

47

3301

J B Hunt Transport Inc

44

04/13/2012 07:01

CBOSL1649 (BOL)

One World Apparel LLC c/o Unger Fabrik

81064

3

47

3301

J B Hunt Transport Inc

45

04/13/2012 07:01

CBOSL1649 (BOL)

One World Apparel LLC c/o Unger Fabrik

81065

3

47

3301

J B Hunt Transport Inc

46

04/13/2012 07:01

CBOSL1649 (BOL)

One World Apparel LLC c/o Unger Fabrik

81066

3

47

3301

J B Hunt Transport Inc

47

04/13/2012 07:01

CBOSL1651 (BOL)

SRP APPAREL c/o Santa Fe Finishing

78863

4

195

6933

J B Hunt Transport Inc

48

04/13/2012 07:01

CBOSL1651 (BOL)

SRP APPAREL c/o Santa Fe Finishing

78864

4

195

6933

J B Hunt Transport Inc

49

04/13/2012 09:30

CBOSL1693-1 (BOL)

Mast Industries Inc

79408

26

691

34443

Non Rev Domestic Carrier

50

04/13/2012 09:30

CBOSL1693-1 (BOL)

Mast Industries Inc

79407

26

691

34443

Non Rev Domestic Carrier

51

04/13/2012 09:30

CBOSL1693-1 (BOL)

Mast Industries Inc

77647

26

691

34443

Non Rev Domestic Carrier

52

04/13/2012 09:30

CBOSL1693-1 (BOL)

Mast Industries Inc

77648

26

691

34443

Non Rev Domestic Carrier

53

04/13/2012 09:30

CBOSL1693-1 (BOL)

Mast Industries Inc

79316

26

691

34443

Non Rev Domestic Carrier

54

04/13/2012 11:31

CBOSL1679-1 (BOL)

GTHL Trading

77374

12

325

39061

J B Hunt Transport Inc

55

04/13/2012 11:31

CBOSL1679-1 (BOL)

GTHL Trading

77375

12

325

39061

J B Hunt Transport Inc

56

04/13/2012 11:31

CBOSL1679-1 (BOL)

GTHL Trading

78075

12

325

39061

J B Hunt Transport Inc

57

04/13/2012 11:31

CBOSL1679-1 (BOL)

GTHL Trading

78138

12

325

39061

J B Hunt Transport Inc

58

04/13/2012 11:31

CBOSL1679-1 (BOL)

GTHL Trading

77367

12

325

39061

J B Hunt Transport Inc

59

04/13/2012 11:31

CBOSL1680-1 (BOL)

Jiangsu Sainty Tech Co

77662

12

794

23116

J B Hunt Transport Inc

60

04/13/2012 11:31

CBOSL1680-1 (BOL)

Jiangsu Sainty Tech Co

77661

12

794

23116

J B Hunt Transport Inc

Sheet

Some rows missing from the bottom due to Excel Jeanie HTML4 restrictions

rjperket · Apr 13, 2012

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
A B C D E F G H
1 Target Delivery (Late) Primary Reference Origin Name PO Number Pallet Count Ctns Quantity Carrier Name
2 04/13/2012 07:00 CBOSL1643-1 (BOL) Two-One-Two New York Inc 77710, 77709, 79687, 79686, 79685, 79684, 79683, 78204, 78203 28 649 23280 Bay & Bay Transfer CO Inc
3 04/13/2012 07:01 CBOSL1605 (BOL) Fred David International USA Inc 77991, 78209, 78210, 78480, 81403, 78574, 78575, 81400, 77990, 78481 15 398 15208 J B Hunt Transport Inc
4 04/13/2012 07:01 CBOSL1609 (BOL) KBL Group Intl 77919, 78191, 78192, 78258, 78259, 78306, 78307, 78852, 78851 28 606 20114 J B Hunt Transport Inc
5 04/13/2012 07:01 CBOSL1644 (BOL) Jordache c/o Command Logistics 77608, 77607 16 1599 13780 J B Hunt Transport Inc
6 04/13/2012 07:01 CBOSL1648 (BOL) Janeric 79955, 77536, 77537, 77649, 77650, 77651, 77652, 79954, 80483 12 284 22685 J B Hunt Transport Inc
7 04/13/2012 07:01 CBOSL1649 (BOL) One World Apparel LLC c/o Unger Fabrik 77864, 77865, 81063, 81064, 81065, 81066 3 47 3301 J B Hunt Transport Inc
8 04/13/2012 07:01 CBOSL1651 (BOL) SRP APPAREL c/o Santa Fe Finishing 78863, 78864 4 195 6933 J B Hunt Transport Inc
9 04/13/2012 09:30 CBOSL1693-1 (BOL) Mast Industries Inc 79408, 79407, 77647, 77648, 79316 26 691 34443 Non Rev Domestic Carrier
10 04/13/2012 11:31 CBOSL1679-1 (BOL) GTHL Trading 77374, 77375, 78075, 78138, 77367 12 325 39061 J B Hunt Transport Inc
11 04/13/2012 11:31 CBOSL1680-1 (BOL) Jiangsu Sainty Tech Co 77662, 77661, 77521, 77520, 77428, 77427, 77426, 77425, 78914, 78915, 78916, 78917, 78942, 78941 12 794 23116 J B Hunt Transport Inc
12 04/13/2012 12:00 CBOSL1641-1 (BOL) Jordache c/o Ditto Apparel 77357 1 37 400 Con-way Freight 8Y
13 04/13/2012 12:00 CBOSL1657-1 (BOL) Fred David Intl USA Inc. C/O Deringer Inc. 81402, 81401 5 64 3434 Con-way Freight 8Y
14 04/13/2012 12:00 CBOSL1691-1 (BOL) Erin London 79089, 79090, 79091, 79092 2 41 1800 Con-way Freight 8Y
15 04/13/2012 12:00 CBOSL1664-1 (BOL) Bluprint Clothing Corp 81478 1 3 300 Non Rev Domestic Carrier
16 04/13/2012 12:00 CBOSL1676-1 (BOL) Bonnie & Norma 78940, 78939 1 23 1350 Non Rev Domestic Carrier
17 04/13/2012 12:00 CBOSL1689-1 (BOL) Tillsonsburg 78555, 78554 1 37 2806 Non Rev Domestic Carrier
18 04/13/2012 12:00 CBOSL1677-1 (BOL) Tanya Creations Inc 79071 1 2 400 Non Rev Domestic Carrier
19 04/13/2012 12:00 CBOSL1678-1 (BOL) Amiee Lynn 78148, 78146 1 14 2755 Non Rev Domestic Carrier
Sheet

becomes this:
Excel Workbook
A B C D E F G H
1 Target Delivery (Late) Primary Reference Origin Name PO Number Pallet Count Ctns Quantity Carrier Name
2 04/13/2012 07:00 CBOSL1643-1 (BOL) Two-One-Two New York Inc 77710 28 649 23280 Bay & Bay Transfer CO Inc
3 04/13/2012 07:00 CBOSL1643-1 (BOL) Two-One-Two New York Inc 77709 28 649 23280 Bay & Bay Transfer CO Inc
4 04/13/2012 07:00 CBOSL1643-1 (BOL) Two-One-Two New York Inc 79687 28 649 23280 Bay & Bay Transfer CO Inc
5 04/13/2012 07:00 CBOSL1643-1 (BOL) Two-One-Two New York Inc 79686 28 649 23280 Bay & Bay Transfer CO Inc
6 04/13/2012 07:00 CBOSL1643-1 (BOL) Two-One-Two New York Inc 79685 28 649 23280 Bay & Bay Transfer CO Inc
7 04/13/2012 07:00 CBOSL1643-1 (BOL) Two-One-Two New York Inc 79684 28 649 23280 Bay & Bay Transfer CO Inc
8 04/13/2012 07:00 CBOSL1643-1 (BOL) Two-One-Two New York Inc 79683 28 649 23280 Bay & Bay Transfer CO Inc
9 04/13/2012 07:00 CBOSL1643-1 (BOL) Two-One-Two New York Inc 78204 28 649 23280 Bay & Bay Transfer CO Inc
10 04/13/2012 07:00 CBOSL1643-1 (BOL) Two-One-Two New York Inc 78203 28 649 23280 Bay & Bay Transfer CO Inc
11 04/13/2012 07:01 CBOSL1605 (BOL) Fred David International USA Inc 77991 15 398 15208 J B Hunt Transport Inc
12 04/13/2012 07:01 CBOSL1605 (BOL) Fred David International USA Inc 78209 15 398 15208 J B Hunt Transport Inc
13 04/13/2012 07:01 CBOSL1605 (BOL) Fred David International USA Inc 78210 15 398 15208 J B Hunt Transport Inc
14 04/13/2012 07:01 CBOSL1605 (BOL) Fred David International USA Inc 78480 15 398 15208 J B Hunt Transport Inc
15 04/13/2012 07:01 CBOSL1605 (BOL) Fred David International USA Inc 81403 15 398 15208 J B Hunt Transport Inc
16 04/13/2012 07:01 CBOSL1605 (BOL) Fred David International USA Inc 78574 15 398 15208 J B Hunt Transport Inc
17 04/13/2012 07:01 CBOSL1605 (BOL) Fred David International USA Inc 78575 15 398 15208 J B Hunt Transport Inc
18 04/13/2012 07:01 CBOSL1605 (BOL) Fred David International USA Inc 81400 15 398 15208 J B Hunt Transport Inc
19 04/13/2012 07:01 CBOSL1605 (BOL) Fred David International USA Inc 77990 15 398 15208 J B Hunt Transport Inc
20 04/13/2012 07:01 CBOSL1605 (BOL) Fred David International USA Inc 78481 15 398 15208 J B Hunt Transport Inc
21 04/13/2012 07:01 CBOSL1609 (BOL) KBL Group Intl 77919 28 606 20114 J B Hunt Transport Inc
22 04/13/2012 07:01 CBOSL1609 (BOL) KBL Group Intl 78191 28 606 20114 J B Hunt Transport Inc
23 04/13/2012 07:01 CBOSL1609 (BOL) KBL Group Intl 78192 28 606 20114 J B Hunt Transport Inc
24 04/13/2012 07:01 CBOSL1609 (BOL) KBL Group Intl 78258 28 606 20114 J B Hunt Transport Inc
25 04/13/2012 07:01 CBOSL1609 (BOL) KBL Group Intl 78259 28 606 20114 J B Hunt Transport Inc
26 04/13/2012 07:01 CBOSL1609 (BOL) KBL Group Intl 78306 28 606 20114 J B Hunt Transport Inc
27 04/13/2012 07:01 CBOSL1609 (BOL) KBL Group Intl 78307 28 606 20114 J B Hunt Transport Inc
28 04/13/2012 07:01 CBOSL1609 (BOL) KBL Group Intl 78852 28 606 20114 J B Hunt Transport Inc
29 04/13/2012 07:01 CBOSL1609 (BOL) KBL Group Intl 78851 28 606 20114 J B Hunt Transport Inc
30 04/13/2012 07:01 CBOSL1644 (BOL) Jordache c/o Command Logistics 77608 16 1599 13780 J B Hunt Transport Inc
31 04/13/2012 07:01 CBOSL1644 (BOL) Jordache c/o Command Logistics 77607 16 1599 13780 J B Hunt Transport Inc
32 04/13/2012 07:01 CBOSL1648 (BOL) Janeric 79955 12 284 22685 J B Hunt Transport Inc
33 04/13/2012 07:01 CBOSL1648 (BOL) Janeric 77536 12 284 22685 J B Hunt Transport Inc
34 04/13/2012 07:01 CBOSL1648 (BOL) Janeric 77537 12 284 22685 J B Hunt Transport Inc
35 04/13/2012 07:01 CBOSL1648 (BOL) Janeric 77649 12 284 22685 J B Hunt Transport Inc
36 04/13/2012 07:01 CBOSL1648 (BOL) Janeric 77650 12 284 22685 J B Hunt Transport Inc
37 04/13/2012 07:01 CBOSL1648 (BOL) Janeric 77651 12 284 22685 J B Hunt Transport Inc
38 04/13/2012 07:01 CBOSL1648 (BOL) Janeric 77652 12 284 22685 J B Hunt Transport Inc
39 04/13/2012 07:01 CBOSL1648 (BOL) Janeric 79954 12 284 22685 J B Hunt Transport Inc
40 04/13/2012 07:01 CBOSL1648 (BOL) Janeric 80483 12 284 22685 J B Hunt Transport Inc
41 04/13/2012 07:01 CBOSL1649 (BOL) One World Apparel LLC c/o Unger Fabrik 77864 3 47 3301 J B Hunt Transport Inc
42 04/13/2012 07:01 CBOSL1649 (BOL) One World Apparel LLC c/o Unger Fabrik 77865 3 47 3301 J B Hunt Transport Inc
43 04/13/2012 07:01 CBOSL1649 (BOL) One World Apparel LLC c/o Unger Fabrik 81063 3 47 3301 J B Hunt Transport Inc
44 04/13/2012 07:01 CBOSL1649 (BOL) One World Apparel LLC c/o Unger Fabrik 81064 3 47 3301 J B Hunt Transport Inc
45 04/13/2012 07:01 CBOSL1649 (BOL) One World Apparel LLC c/o Unger Fabrik 81065 3 47 3301 J B Hunt Transport Inc
46 04/13/2012 07:01 CBOSL1649 (BOL) One World Apparel LLC c/o Unger Fabrik 81066 3 47 3301 J B Hunt Transport Inc
47 04/13/2012 07:01 CBOSL1651 (BOL) SRP APPAREL c/o Santa Fe Finishing 78863 4 195 6933 J B Hunt Transport Inc
48 04/13/2012 07:01 CBOSL1651 (BOL) SRP APPAREL c/o Santa Fe Finishing 78864 4 195 6933 J B Hunt Transport Inc
49 04/13/2012 09:30 CBOSL1693-1 (BOL) Mast Industries Inc 79408 26 691 34443 Non Rev Domestic Carrier
50 04/13/2012 09:30 CBOSL1693-1 (BOL) Mast Industries Inc 79407 26 691 34443 Non Rev Domestic Carrier
51 04/13/2012 09:30 CBOSL1693-1 (BOL) Mast Industries Inc 77647 26 691 34443 Non Rev Domestic Carrier
52 04/13/2012 09:30 CBOSL1693-1 (BOL) Mast Industries Inc 77648 26 691 34443 Non Rev Domestic Carrier
53 04/13/2012 09:30 CBOSL1693-1 (BOL) Mast Industries Inc 79316 26 691 34443 Non Rev Domestic Carrier
54 04/13/2012 11:31 CBOSL1679-1 (BOL) GTHL Trading 77374 12 325 39061 J B Hunt Transport Inc
55 04/13/2012 11:31 CBOSL1679-1 (BOL) GTHL Trading 77375 12 325 39061 J B Hunt Transport Inc
56 04/13/2012 11:31 CBOSL1679-1 (BOL) GTHL Trading 78075 12 325 39061 J B Hunt Transport Inc
57 04/13/2012 11:31 CBOSL1679-1 (BOL) GTHL Trading 78138 12 325 39061 J B Hunt Transport Inc
58 04/13/2012 11:31 CBOSL1679-1 (BOL) GTHL Trading 77367 12 325 39061 J B Hunt Transport Inc
59 04/13/2012 11:31 CBOSL1680-1 (BOL) Jiangsu Sainty Tech Co 77662 12 794 23116 J B Hunt Transport Inc
60 04/13/2012 11:31 CBOSL1680-1 (BOL) Jiangsu Sainty Tech Co 77661 12 794 23116 J B Hunt Transport Inc
Sheet

Some rows missing from the bottom due to Excel Jeanie HTML4 restrictions

Reformat a list in a single column into multiple rows.

rjperket

New Member

Excel Facts

p45cal

Well-known Member

rjperket

New Member

p45cal

Well-known Member

rjperket

New Member

Similar threads

Forum statistics

Share this page

Reformat a list in a single column into multiple rows.

rjperket

New Member

Excel Facts

p45cal

Well-known Member

rjperket

New Member

p45cal

Well-known Member

rjperket

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock