title: How to get lines in to colums? SExt Query
body: <p>Here the query i wrote very simple.</p>
  <pre><code> SELECT        GeneralLedger, YEAR(ReportingDate) AS jaar, MONTH(ReportingDate) AS periode, SUM(AmountDCDebit - AmountDCCredit) AS Saldo
  FROM            dbo.GeneralLedgerBalances
  GROUP BY GeneralLedger, YEAR(ReportingDate), MONTH(ReportingDate)
  HAVING        (YEAR(ReportingDate) = 2020)
  </code></pre>
  <p>the result i get is</p>
  <p><img src="https://i.stack.imgur.com/G1vif.png" alt="enter image description here" /></p>
  <p>How ever i wan to get this result:</p>
  <p><img src="https://i.stack.imgur.com/JDMv2.png" alt="enter image description here" /></p>
  <p>I want to get the periods in a column How can I change my query?</p>