Converting data Wide to long with dates

[joseulloa22]

Hello,
I was trying to convert the following table

[TABLE="width: 293"]
<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>[TR]
[TD="width: 94, bgcolor: transparent"]ITEM_NAME[/TD]
[TD="width: 85, bgcolor: transparent, align: right"] 7/30/2018
[/TD]
[TD="width: 68, bgcolor: transparent, align: right"]8/27/2018[/TD]
[TD="width: 68, bgcolor: transparent, align: right"]10/1/2018[/TD]
[TD="width: 75, bgcolor: transparent, align: right"]10/29/2018
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1690ZZ[/TD]
[TD="bgcolor: transparent, align: right"]130[/TD]
[TD="bgcolor: transparent, align: right"]162[/TD]
[TD="bgcolor: transparent, align: right"]162[/TD]
[TD="bgcolor: transparent, align: right"]162[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1692ZK[/TD]
[TD="bgcolor: transparent, align: right"]72[/TD]
[TD="bgcolor: transparent, align: right"]70[/TD]
[TD="bgcolor: transparent, align: right"]171[/TD]
[TD="bgcolor: transparent, align: right"]70[/TD]
[/TR]
</tbody>[/TABLE]
........ ..... ..... ....... .....



into

[TABLE="width: 186"]
<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>[TR]
[TD="width: 94, bgcolor: transparent"]1690ZZ[/TD]
[TD="width: 85, bgcolor: transparent, align: right"]7/30/2018[/TD]
[TD="width: 68, bgcolor: transparent, align: right"]130[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1690ZZ[/TD]
[TD="bgcolor: transparent, align: right"]8/27/2018[/TD]
[TD="bgcolor: transparent, align: right"]162[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1690ZZ[/TD]
[TD="bgcolor: transparent, align: right"]10/1/2018[/TD]
[TD="bgcolor: transparent, align: right"]162[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1690ZZ[/TD]
[TD="bgcolor: transparent, align: right"]10/29/2018[/TD]
[TD="bgcolor: transparent, align: right"]162[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1692ZK[/TD]
[TD="bgcolor: transparent, align: right"]7/30/2018[/TD]
[TD="bgcolor: transparent, align: right"]72[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1692ZK[/TD]
[TD="bgcolor: transparent, align: right"]8/27/2018[/TD]
[TD="bgcolor: transparent, align: right"]70[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1692ZK[/TD]
[TD="bgcolor: transparent, align: right"]10/1/2018[/TD]
[TD="bgcolor: transparent, align: right"]171[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1692ZK[/TD]
[TD="bgcolor: transparent, align: right"]10/29/2018[/TD]
[TD="bgcolor: transparent, align: right"]70[/TD]
[/TR]
</tbody>[/TABLE]

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.