Transposition of data

[rashid0146]

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

 

[azumi]

Please Im provide you the example file

https://simpan.ugm.ac.id/s/OzQXKsNmFbQtUIO

 

[rashid0146]

Please Im provide you the example file

https://simpan.ugm.ac.id/s/OzQXKsNmFbQtUIO

Azumi Thanks alot