We do have a price file which needs to be restructured as follows:
——————-
I (EUR) J (USD)
20 30
35 46
——————-
into:
——————-
A (Currency) K (Price)
EUR 20
EUR 35
USD 30
USD 46
The excel contains 10+ columns, so each additional row that is created will also need the content from all the other rows. Attached is an example file, the real file will contain about 900 rows of data and a few co…
