maheshrk81
Board Regular
- Joined
- Jan 5, 2010
- Messages
- 153
Hi All,
I have a data as below. Now I need the same with Cust ID, Cust Name and 3rd Column as Fiscal Month and get the Month column to Rows and 4th Column as Amount and get those in rows respectively. Can someone help
<tbody>
</tbody>
Thanks,
Mahi
I have a data as below. Now I need the same with Cust ID, Cust Name and 3rd Column as Fiscal Month and get the Month column to Rows and 4th Column as Amount and get those in rows respectively. Can someone help
Cust ID | Cust Name<strike></strike> | [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]Jul[/FONT]<strike></strike> | Aug<strike></strike> | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | |
124 | abc | 654654 | 566 | 155 | 6496 | 65467 | 686 | 886 | 9963 | 966 | 9863 | 35 | 668 | |
416546 | wer | 48 | 56698 | 656 | 6633 | 666 | 6623 | 335 | 333 | 8 | 66 | 77 | ||
665265 | thj | 6864 | 6289 | 66 | 566 | 6645 | 582 | 33 | 6366 | 65 | 366 | 98 | 546 | |
65654 | yui | 967 | ||||||||||||
9852 | opz | 646 | 339 | |||||||||||
6823 | tre | 649 | 33694 | |||||||||||
57 | xyz | 888 | 669 | |||||||||||
783 | pqr | 698 | 3969 | |||||||||||
<tbody>
</tbody>
Thanks,
Mahi