labo2002
01-23-2019, 06:02 AM
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:
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: