Jes Sie

Jes Sie

  • 691
  • 1.2k
  • 262.5k

Pivoting Multiple Columns

Jul 29 2022 1:32 AM

Is there a way where I can pivot multiple columns from my table to pivot into 3 currencies (LAK, THB, USD). The columns I want to pivot are premium, discountedPremium, registryFee, vat, etc. Please see image below.

I want the result to be like in the image below:

thank you for your guidance.


Answers (8)