Need to break transpose at specific rows depending on the cell content. How? : So I am working on this excel/spreadsheet project where I have to achieve:

**FROM: (assuming that Fruit is in cell A1)**
[I have this][1]

TO: (Assuming that Fruit Summary is in Cell I1)
[I want to achieve this][2]

Banging my head over this for days.
Please help!
  [1]: https://i.stack.imgur.com/jP6oH.png
  [2]: https://i.stack.imgur.com/BMezv.png