rashid0146
New Member
- Joined
- Dec 27, 2016
- Messages
- 7
I have data in excel as follow
Employee code BSALY MDALLW HRA
BM-0001 148,000 14,850 66,825
BM-0002 45,454 15,000 30,000
I want data as follow
Employee Code
BM-0001 BSALY 148,500
BM-0001 MDALLW 14,850
BM-0001 HRA 66,825
BM-0002 BSALY 45,454
BM-0002 MDALLW 15,000
BM-0002 HRA 30,000
Please guide what formula can help to get me the desired output.
Thanks
Rashid Anwar
Employee code BSALY MDALLW HRA
BM-0001 148,000 14,850 66,825
BM-0002 45,454 15,000 30,000
I want data as follow
Employee Code
BM-0001 BSALY 148,500
BM-0001 MDALLW 14,850
BM-0001 HRA 66,825
BM-0002 BSALY 45,454
BM-0002 MDALLW 15,000
BM-0002 HRA 30,000
Please guide what formula can help to get me the desired output.
Thanks
Rashid Anwar