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.

UNIT	TYPE	10/1/17	10/1/17	10/2/17	10/2/17	10/3/17
12V1223	BOX	CUST 1	CUST 1	CUST 2	CUST 3	CUST 4
15V1245	BOX	CUST 1	CUST 1	CUST 2	CUST 3	CUST 4
16V1250	BOX	CUST 1	CUST 1	CUST 2	CUST 3	CUST 4
15F1244	FLATBED	CUST 1	CUST 1	CUST 2	CUST 4	CUST 4
7751408	FLATBED	CUST 1	CUST 1	CUST 2	CUST 3	CUST 4
7751458	REEFER	CUST 1	CUST 1	CUST 2	CUST 3	CUST 4
142525	SAD	CUST 1	CUST 1	CUST 2	CUST 3	CUST 4
7751404	SAD	CUST 1	CUST 1	CUST 2	CUST 3	CUST 4
133515	TAD	CUST 1	CUST 1	CUST 2	CUST 3	CUST 4
163536	TAD	CUST 1	CUST 1	CUST 2	CUST 3	CUST 4

<colgroup><col><col><col span="5"></colgroup><tbody>
</tbody>

 

[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