Dear members
I am facing an issue with some data which is available with me in MS-Excel in the following format:
SALES SALES SALES COGS COGS COGS
Company ISIN 2016 2017 2018 2016 2017 2018
A IN123456 344 400 410 300 325 330
B JP112345 549 520 510 480 478 470
C AU235678 218 345 490 240 300 400
I would like to convert it in the following format:
Company ISIN Year SALES COGS
A IN123456 2016 344 300
B JP112345 2016 549 480
C AU235678 2016 218 240
A IN123456 2017 400 325
B JP112345 2017 520 478
C AU235678 2017 345 300
A IN123456 2018 410 330
B JP112345 2018 510 470
C AU235678 2018 490 400

Can this be done through Stata commands? If yes, please share possible ways to do it.

Thanks in advance