Pivoting Multiple Columns

WITH PivotedData AS (
  SELECT 
    id,
    CASE WHEN premium_currency = 'LAK' THEN premium ELSE NULL END AS premium_LAK,
    CASE WHEN premium_currency = 'THB' THEN premium ELSE NULL END AS premium_THB,
    CASE WHEN premium_currency = 'USD' THEN premium ELSE NULL END AS premium_USD,
    CASE WHEN discountedPremium_currency = 'LAK' THEN discountedPremium ELSE NULL END AS discountedPremium_LAK,
    CASE WHEN discountedPremium_currency = 'THB' THEN discountedPremium ELSE NULL END AS discountedPremium_THB,
    CASE WHEN discountedPremium_currency = 'USD' THEN discountedPremium ELSE NULL END AS discountedPremium_USD,
    CASE WHEN registryFee_currency = 'LAK' THEN registryFee ELSE NULL END AS registryFee_LAK,
    CASE WHEN registryFee_currency = 'THB' THEN registryFee ELSE NULL END AS registryFee_THB,
    CASE WHEN registryFee_currency = 'USD' THEN registryFee ELSE NULL END AS registryFee_USD,
    CASE WHEN vat_currency = 'LAK' THEN vat ELSE NULL END AS vat_LAK,
    CASE WHEN vat_currency = 'THB' THEN vat ELSE NULL END AS vat_THB,
    CASE WHEN vat_currency = 'USD' THEN vat ELSE NULL END AS vat_USD
  FROM transactions
)
SELECT 
  id,
  MAX(premium_LAK) AS premium_LAK,
  MAX(premium_THB) AS premium_THB,
  MAX(premium_USD) AS premium_USD,
  MAX(discountedPremium_LAK) AS discountedPremium_LAK,
  MAX(discountedPremium_THB) AS discountedPremium_THB,
  MAX(discountedPremium_USD) AS discountedPremium_USD,
  MAX(registryFee_LAK) AS registryFee_LAK,
  MAX(registryFee_THB) AS registryFee_THB,
  MAX(registryFee_USD) AS registryFee_USD,
  MAX(vat_LAK) AS vat_LAK,
  MAX(vat_THB) AS vat_THB,
  MAX(vat_USD) AS vat_USD
FROM PivotedData
GROUP BY id;

A Common Table Expression (CTE) to pivot each field individually based on the currency and then aggregates the results using MAX to remove NULL values and get the desired format.