title: Steps to manipulate XLS to JSON like this
body: <p>Very new to SwiftUI and reading data from JSON files, but getting there.  Could experts in the community advise please how I get from the data in Excel to the format required in JSON.</p>
  <p>In Excel I have this...</p>
  <p><a href="https://i.stack.imgur.com/043Rg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/043Rg.png" alt="enter image description here" /></a></p>
  <p>... and what I would like from that data in Excel is for my JSON file to be like this...</p>
  <p><a href="https://i.stack.imgur.com/vbfY0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vbfY0.png" alt="enter image description here" /></a></p>
  <p>Could someone advise the steps I'd need to take to get from a to b please.  Wondering if this can be done in one step, or if it has to be multiple.</p>
  <p>Essentially the code I am writing needs to select 'n' questions from each SylabusItem.  So in this example, Question 1 in the exam would need 2 questions presented to the student from a selection of those with the same SylabusItem. So, in this case 2 from 3. Subsequent questions will vary of course.</p>
  <p>Thoughts?
  Thanks.</p>