Converting data Wide to long with dates

[joseulloa22]

Hello,
I was trying to convert the following table

ITEM_NAME	7/30/2018	8/27/2018	10/1/2018	10/29/2018
1690ZZ	130	162	162	162
1692ZK	72	70	171	70

<colgroup><col width="94" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;"> <col width="85" style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;" span="2"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <tbody> </tbody>

........ ..... ..... ....... .....



into

1690ZZ	7/30/2018	130
1690ZZ	8/27/2018	162
1690ZZ	10/1/2018	162
1690ZZ	10/29/2018	162
1692ZK	7/30/2018	72
1692ZK	8/27/2018	70
1692ZK	10/1/2018	171
1692ZK	10/29/2018	70

<colgroup><col width="94" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;"> <col width="85" style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;"> <tbody> </tbody>

This is an example but my table has more data. Your wisdom is greatly appreciated

 

[Peter_SSs]

Phenomenal. This is truly marvelous!

Thanks much for your help Peter!

Jose

You are very welcome.

Peter, is there any good Excel VBA book for beginners you can recommend? I am just fascinated!
Jose

I didn't use books, mostly just this forum, a bit of Googling & lots of trial & error.