title: How can I group by (like an Excel pivot table?) my minute bar data
body: <p>I have a table created as follows:</p>
  
  <pre><code>CREATE TABLE [1M].[FLOWERS](
      [utcDT] [datetime2](7) NOT NULL,
      [Symbol] [nvarchar](50) NULL,
      [Open] [float] NULL,
      [High] [float] NULL,
      [Low] [float] NULL,
      [Close] [float] NULL
  ) ON [PRIMARY]
  </code></pre>
  
  <p>How can I create a table such that I get a column for each different [Symbol] and value in column is the [Close] grouped by [utcDT]</p>
  
  <p>Assume there are 10 different symbols.</p>
  
  <p>I want:</p>
  
  <pre><code>utcDT,Symbol1,Symbol2,...,Symbol10
  10:23,1.1    ,1.2    ,...,1.07
  10:24,1.3    ,1.2    ,...,1.09
  10:25,1.2    ,1.3    ,...,1.10
  </code></pre>
  
  <p>In Excel this is easily done with a pivot table. How can I achieve this in SQL?</p>