Need Help : How to do convert 1 table to another format

[labo2002]

Hi,

i have been banging my head as im currently experiencing a mental block.
I need to do a conversion of table of raw data to a different format.

Raw Data


Date
Day
ProductA
ProductB


01/01/2019
Tue
10
5


02/01/2019
Wed
5
10


03/01/2019
Thu
14
14


04/01/2019
Fri
15
18




New Table Data


Date
Day
Product
Volume


01/01/2019
Tue
ProductA
10


01/01/2019
Tue
ProductB
5


02/01/2019
Wed
ProductA
5


02/01/2019
Wed
ProductB
10


03/01/2019
Thu
ProductA
14


03/01/2019
Thu
ProductB
14


04/01/2019
Fri
ProductA
15


04/01/2019
Fri
ProductB
18


Any help will be greatly appreciated.:crying::crying::crying::crying:

[p45cal]

try:
https://www.dropbox.com/s/gel0dg7xadxottp/Media1.mp4?dl=0
It's a link to a video.

[labo2002]

cannot access the link. :(

[p45cal]

cannot access the link. :(

Funny, I tested it from another computer. It's an mp4 file which might need a player of some sort. Are you able to download and save it to your computer?

[Paul_Hossler]

I have to do something like that all the time to make a 'two dimensional' block of data into a pivot table friendly list

I wrote a macro for a general purpose solution

23614

[p45cal]

I have to do something like that all the timePaul, are you able to gain access to my linked-to file? I ask because the OP says he can't.

[Paul_Hossler]

Accessed it with no problems

Maybe the OP didn't noticed that the Logon screen had a 'No thanks, Continue to view' option ???

[p45cal]

Accessed it with no problemsThanks Paul.