How to break transpose at specific rows depending on the cell content?

Question

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

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

In these few days, what have you tried? `SUMIFS()`, `COUNTIFS()`? Also are you looking for an Excel solution, or Google Spreadsheets solution? — BruceWayne, Aug 24 '17 at 05:59
I tried SUMIFS() but couldnt figure it out. This worked like a charm though: =QUERY (A1:G11,"select A, Count (A),Sum(G),sum(D) group by A") — user141975, Sep 03 '17 at 21:15

score -1 · Accepted Answer · edited Aug 24 '17 at 07:37

-1

=QUERY (A1:G11,"select A, Count (A),Sum(G),sum(D) group by A")

edited Aug 24 '17 at 07:37

Steve Piercy

answered Aug 24 '17 at 06:09

TheMaster

Wow! You made it look so easy, Works like charm! Saved my butt Steve! Thanks a lot. – user141975 Sep 03 '17 at 21:14
I answered -_- Steve only removed 4 spaces from my answer for formatting. – TheMaster Sep 04 '17 at 04:09
Oh I am so sorry. I am new here and didnt know how it showed. My bad, you answered anonymous!! Thank you! And steve thank you too for editing it. – user141975 Sep 04 '17 at 04:36

1 Answers1