title: Reformatting a Json Array that's been converted from Excel using https://tableconvert.com/excel-to-json
body: <p>This is the output I am getting from the Website</p>
  <pre><code>{
          &quot;paymentNo&quot;: &quot;1&quot;,
          &quot;Text&quot;: &quot;Zahlbar sofort nach Erhalt der Rechnung ohne Abzug&quot;,
          &quot;discountDays&quot;: &quot;&quot;,
          &quot;discountPercent&quot;: &quot;&quot;,
          &quot;paymentDays&quot;: &quot;0&quot;,
          &quot;Client&quot;: &quot;9f5ab9c4-28a5-4e7b-a754-e53fce5a5026&quot;
      }
  </code></pre>
  <p>This is the format I need to convert it to</p>
  <pre><code>{
          &quot;paymentNo&quot;: &quot;1&quot;,
          &quot;Text&quot;: &quot;Zahlbar sofort nach Erhalt der Rechnung ohne Abzug&quot;,
          &quot;Client&quot;: &quot;9f5ab9c4-28a5-4e7b-a754-e53fce5a5026&quot;,
          &quot;paymentDays&quot;: &quot;0&quot;,
          &quot;discounts&quot;: [
          {
          &quot;discountDays&quot;: &quot;&quot;,
           &quot;discountPercent&quot;: &quot;&quot;
          }
          ]
          
          
          
      }
  </code></pre>
  <p>I have over 200 transformations like this I need to get done, which I've been doing by hand. I'm at number 22 and I'm slowly loosing my mind. There has to be a better way to do this.</p>
  <p>Does anyone have some resources that teach how to automate this reformatting?</p>