title: How to create multiple columns based on the unique values in a single column? (presto SQL)
body: <p>I have the following data in the below example.</p>
  <pre><code>account_id, campaign_objective, campaign_spend, conversions
  __________, __________________, ______________, ___________
  1,          sales,              100,            25
  1,          brand,              50,             25
  2,          sales,              80,             12
  2,          brand,              60,             12
  </code></pre>
  <p>What I would like to do is create one column for each unique campaign_objective and assign it the corresponding spend value.</p>
  <pre><code>account_id, sales, brand, conversions
  __________, _____, _____, ___________
  1,          100,   50,    25
  2,          80,    60,    12 
  </code></pre>
  <p>Notice how first, account_id and conversions remain unchanged, they're just consolidated to a single row per account_id but second, each campaign objective receives its own column (sales and brand) and the spend values corresponding to the account_id are entered under the appropriate columns (spend and brand, respectively.)</p>
  <p>How can I accomplish this in Presto SQL?</p>