0

I have this set of data in Microsoft Excel 365

enter image description here

I want to transform it into following format

enter image description here

The first format reads for example, for Weight=3 ounces and Country=MX, the tarrifs would be $1.75. Instead of a table presentation I would like a simple row representation.

enter image description here

I tried a few options like Formulaes, string concatenate but results were not satisfying.

  1. What is the correct terminology for first represetantion of data and second represenation?
  2. What is the trasforamation callled?
  3. How do I trasnform?
HappyTown
  • 5,464
  • 7
  • 34
  • 48

0 Answers0