Manipulating Data Into Format Suitable for Pivot Tables

[hockey390]

Hi All,

I am working with the below format of data extract. As you can see, all of the data is in a column under the dates listed in grey.
What I'm wondering is if there is a way to convert this into a pivot table friendly format in excel. Because the headers in grey are dates that change and from all the searching I've done online, it doesn't appear to be a way to pull this into a pivot table as is to display the Values under the dates for each row.

Customer Item	Column7	Column9	Column10	1/27/19	2/3/19	2/10/19	2/17/19	2/24/19	3/3/19
103322	6	220800-09	87					80
103322	15	220800-09	14
103322	11	220800-09	17					30
103322	10	220800-09	8
103322	12	220800-09	21						24
103322	4	220800-09	17		80
103322	3	220800-09	60
103322	5	220800-09	62				80
103349	1	220800-06	45	30		30	30		30
103349	5	220800-06	110			80			80
103349	3	220800-06	71
103349	12	220800-06	22
103411	15	220800-09	6		8	8		8
103411	6	220800-09	61					64
103411	20	220800-09	147				192
103411	10	220800-09	170			64		64

<tbody>
</tbody>

An example of what I think it would need to look like is below. I have only pasted a portion of the entire data field as I didn't want to create an eyesore. The info in the first4 columns repeats with a change in "date" to reflect the quantities.

Customer Item	Column7	Column9	Column10	Date	Qty
103322	6	220800-09	87	1/27/19
103322	15	220800-09	14	1/27/19
103322	11	220800-09	17	1/27/19
103322	10	220800-09	8	1/27/19
103322	12	220800-09	21	1/27/19
103322	4	220800-09	17	1/27/19
103322	3	220800-09	60	1/27/19
103322	5	220800-09	62	1/27/19
103349	1	220800-06	45	1/27/19	30
103349	5	220800-06	110	1/27/19
103349	3	220800-06	71	1/27/19
103349	12	220800-06	22	1/27/19
103411	15	220800-09	6	1/27/19
103411	6	220800-09	61	1/27/19
103411	20	220800-09	147	1/27/19
103411	10	220800-09	170	1/27/19
103322	6	220800-09	87	2/3/19
103322	15	220800-09	14	2/3/19
103322	11	220800-09	17	2/3/19
103322	10	220800-09	8	2/3/19

<tbody>
</tbody>