Populate a column based on another matching row in Excel
I have an excel file which looks like below and contains about 50000 rows.
OrderNum ProductID Printlabel USPrice IntPrice Currency Amount
123 R24T CA123 USD 40
123 R24T CA123 Euro 30.82
What I need is:
OrderNum ProductID Printlabel USPrice IntPrice Currency Amount
123 R24T CA123 40 30.83 USD 40
123 R24T CA123 30.83 40 Euro 30.82
Basically I want to populate the USPrice and IntPrice depending on the Currency. Most of my orders except a few will have two rows, one for US and one for International. Currency will have only two possible values: "Euros" and "USD".
Any help will be greatly appreciated.
I have an excel file which looks like below and contains about 50000 rows.
OrderNum ProductID Printlabel USPrice IntPrice Currency Amount
123 R24T CA123 USD 40
123 R24T CA123 Euro 30.82
What I need is:
OrderNum ProductID Printlabel USPrice IntPrice Currency Amount
123 R24T CA123 40 30.83 USD 40
123 R24T CA123 30.83 40 Euro 30.82
Basically I want to populate the USPrice and IntPrice depending on the Currency. Most of my orders except a few will have two rows, one for US and one for International. Currency will have only two possible values: "Euros" and "USD".
Any help will be greatly appreciated.
No comments:
Post a Comment