askall1000
Board Regular
- Joined
- Jan 3, 2019
- Messages
- 58
- Office Version
- 2016
- Platform
- Windows
Hello All,
I want to convert column headers and then insert rows for usd, eur and other currencies, when transpose this data i will calculate x currency with f/x rate. I want to transpose with formula because i need to do this transpose each month. Thank you very much for your help in advance (I am using company laptop, sorry for lack of add-ins that i can upload, i could only share image of excel, my Ms Excel version is 365).
I want to convert column headers and then insert rows for usd, eur and other currencies, when transpose this data i will calculate x currency with f/x rate. I want to transpose with formula because i need to do this transpose each month. Thank you very much for your help in advance (I am using company laptop, sorry for lack of add-ins that i can upload, i could only share image of excel, my Ms Excel version is 365).