Create new rows with column data

[emi94]

Hello, 

Can someone help with this:

I want to go from this:

ID	Account	Oct 2010	Nov 2010	Dec 2010	...
22	tr	4	5	3	...
24	re	7	2	1	...

To this: 

ID	Account	Date	value
22	tr	Oct 2010	4
22	tr	Nov 2010	5
22	tr	Dec 2010	3
24	re	Oct 2010	7
24	re	Nov 2010	2
24	re	Dec 2010	1

thanks, 

[JagdeeshN]

Hi @emi94 ,

The transpose tool should do the trick for you.

Please find attached a sample.

Hope this helps.

Best,

Jagdeesh

[binay2448]

Find attached solution...