title: Aggregate same row groups into one row
body: <p>I have a table with 30 columns. All but two column (<strong>CropVariety, Date</strong>) values in the same row groups are the same. I want to <strong>aggregate groups of rows with the same column values (except CropVariety, Date</strong>) into one row, stack different column values into one cell.</p>
  <pre><code>Exapmple:
  
  ID      Field      Year IDFarm Farm   Type         CropVariety  Date
  1222980 MU-9 - EKO 2020 219255  MU    Cover Crop   Rice         2020-04-03
  1222980 MU-9 - EKO 2020 219255  MU    Cover Crop   Soy          2020-04-07
  3333333 AB-9 - EKO 2020 444444  AB    Cover Crop   Lentil       2020-05-03
  3333333 AB-9 - EKO 2020 444444  AB    Cover Crop   Hemp         2020-05-07
  
  
  Desired output:
  
  ID      Field      Year IDFarm Farm   Type         CropVariety  Date
  1222980 MU-9 - EKO 2020 219255  MU    Cover Crop   Rice, Soy    2020-04-03, 2020-04-07
  3333333 AB-9 - EKO 2020 444444  AB    Cover Crop   Lentil, Hemp 2020-05-03, 2020-05-07
  </code></pre>
  <p>I assume i should use <strong>ARRAY_AGG</strong> or <strong>ARRAY_CONCAT_AGG</strong> function, but my formulas were always wrong so i don't know really how to use is.</p>