crosstable issue...

[#1]

Hi guys,

I have a data which i need to transform it in to new format using crosstable.

date_time	Total	AC	Tubelight	Computer
8/8/2013 12:15	67	25	30	12
8/9/2013 1:20	128	50	54	24
8/10/2013 2:17	202	60	55	87
8/11/2013 21:30	97	65	22	10

Now i want to convert this data in below format,

date_time	Total	Product	value
8/8/2013 12:15	67	AC	25
8/8/2013 12:15	67	Tubelight	30
8/8/2013 12:15	67	Computer	12
8/9/2013 1:20	128	AC	50
8/9/2013 1:20	128	Tubelight	54
8/9/2013 1:20	128	Computer	24
8/10/2013 2:17	202	AC	60
8/10/2013 2:17	202	Tubelight	55
8/10/2013 2:17	202	Computer	87
8/11/2013 21:30	97	AC	65
8/11/2013 21:30	97	Tubelight	22
8/11/2013 21:30	97	Computer	10

please guide.

thanks,
hitesh

[Gysbert_Wassenaar · Accepted solution]

ResultTable:

Crosstable(Product,value,2)

Load * from ...somewhere...;

[#3]

thanks a lot gysbert.