Sorting Data

[FALLSILENT]

I'm trying to use this table to feed to a second sheet that will break down how many times customers had each unit, and how many times of what type. Everything I've done has resulted in counting every instance of a name. Sometimes a customer has a unit for a few days, sometimes just a day. I tried a pivot table, but if CUST 1 had the unit first, every customer after fell into a sub-group of that first.

[TABLE="width: 758"]
<colgroup><col><col><col span="5"></colgroup><tbody>[TR]
[TD]UNIT[/TD]
[TD]TYPE[/TD]
[TD]10/1/17[/TD]
[TD]10/1/17[/TD]
[TD]10/2/17[/TD]
[TD]10/2/17[/TD]
[TD]10/3/17[/TD]
[/TR]
[TR]
[TD]12V1223[/TD]
[TD]BOX
[/TD]
[TD]CUST 1[/TD]
[TD]CUST 1[/TD]
[TD]CUST 2[/TD]
[TD]CUST 3[/TD]
[TD]CUST 4[/TD]
[/TR]
[TR]
[TD]15V1245[/TD]
[TD]BOX[/TD]
[TD]CUST 1[/TD]
[TD]CUST 1[/TD]
[TD]CUST 2[/TD]
[TD]CUST 3[/TD]
[TD]CUST 4[/TD]
[/TR]
[TR]
[TD]16V1250[/TD]
[TD]BOX[/TD]
[TD]CUST 1[/TD]
[TD]CUST 1[/TD]
[TD]CUST 2[/TD]
[TD]CUST 3[/TD]
[TD]CUST 4[/TD]
[/TR]
[TR]
[TD]15F1244[/TD]
[TD]FLATBED[/TD]
[TD]CUST 1[/TD]
[TD]CUST 1[/TD]
[TD]CUST 2[/TD]
[TD]CUST 4[/TD]
[TD]CUST 4[/TD]
[/TR]
[TR]
[TD]7751408[/TD]
[TD]FLATBED[/TD]
[TD]CUST 1[/TD]
[TD]CUST 1[/TD]
[TD]CUST 2[/TD]
[TD]CUST 3[/TD]
[TD]CUST 4[/TD]
[/TR]
[TR]
[TD]7751458[/TD]
[TD]REEFER[/TD]
[TD]CUST 1[/TD]
[TD]CUST 1[/TD]
[TD]CUST 2[/TD]
[TD]CUST 3[/TD]
[TD]CUST 4[/TD]
[/TR]
[TR]
[TD]142525[/TD]
[TD]SAD[/TD]
[TD]CUST 1[/TD]
[TD]CUST 1[/TD]
[TD]CUST 2[/TD]
[TD]CUST 3[/TD]
[TD]CUST 4[/TD]
[/TR]
[TR]
[TD]7751404[/TD]
[TD]SAD[/TD]
[TD]CUST 1[/TD]
[TD]CUST 1[/TD]
[TD]CUST 2[/TD]
[TD]CUST 3[/TD]
[TD]CUST 4[/TD]
[/TR]
[TR]
[TD]133515[/TD]
[TD]TAD[/TD]
[TD]CUST 1[/TD]
[TD]CUST 1[/TD]
[TD]CUST 2[/TD]
[TD]CUST 3[/TD]
[TD]CUST 4[/TD]
[/TR]
[TR]
[TD]163536[/TD]
[TD]TAD[/TD]
[TD]CUST 1[/TD]
[TD]CUST 1[/TD]
[TD]CUST 2[/TD]
[TD]CUST 3[/TD]
[TD]CUST 4[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Within Excel hit Alt F8, a dialogue box will appear called Macro.
Is there anything in it?

 

[FALLSILENT]

Alt-F11-Insert-Module-Paste Formula. Get Out and F8 and the box is empty. I did notice that when I paste the formula "Sub Unwind()Dim ws As Worksheet" Is in red.

 

[Fluff]

It should be

Sub Unwind()
Dim ws As Worksheet

 

[FALLSILENT]

Now When I Alt-F8 I get "Run-time error '9':
Subscript out of range