Macro to move column header dates to row for each unique item

[noxvoortella]

Hey folks! I have columns of sales data (text), and then dates across columns as well. I want to take those dates and format them into one row so each date matches up to each row of text data. Below is a sample of some of the data, but I have 171 rows would like reformatted and dates from 8/5/2017- 8/5/2018.

Current Format:

PRODUCT	SALES REP	CORP GRP	8/5/2017	8/12/2017	8/19/2017
340493 <colgroup><col width="65"></colgroup><tbody> </tbody>	Cherilyn <colgroup><col width="122"></colgroup><tbody> </tbody>	Nicholas <colgroup><col width="172"></colgroup><tbody> </tbody>
340493	Brian <colgroup><col width="122"></colgroup><tbody> </tbody>	FSA <colgroup><col width="172"></colgroup><tbody> </tbody>
340493	Joe	Clemson <colgroup><col width="172"></colgroup><tbody> </tbody>
340493	Jerrald <colgroup><col width="122"></colgroup><tbody> </tbody>	Other - Food Svc NW/Intm <colgroup><col width="172"></colgroup><tbody> </tbody>

<tbody>
</tbody>

Desired Format:

PRODUCT	SALES REP	CORP GRP	DATE
340493	Cherilyn	Nicholas	8/5/2017
340493	Brian	FSA	8/5/2017
340493	Joe	Clemson	8/5/2017
340493	Jerrald	Other - Food Svc NW/Intm <tbody> </tbody>	8/5/2017
340493	Cherilyn	Nicholas	8/12/2017
340493	Brian	FSA	8/12/2017
340493	Joe	Clemson	8/12/2017
340493	Jerrald	Other - Food Svc NW/Intm	8/12/2017
340493	Cherilyn	Nicholas	8/19/2017
340493	Brian	FSA	8/19/2017
340493	Joe	Clemson	8/19/2017
340493	Jerrald	Other - Food Svc NW/Intm	8/19/2017

<tbody>
</tbody>

I'm not good with VBA/Macros, but could use some help, thank you!