0

This image shows what i am needing to achieve. I dont know how to do it. Any help will be welcome.

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124
Gabriel Katzberg
  • 31
  • 5
  • What program? Excel, Google Sheets, or LibreOffice Calc? The approach will be different depending on which one. Look up reverse pivoting. – BigBen Aug 05 '20 at 17:07
  • Ideally google-sheets. But if there is a solution in the other spreadhseet will also help. Thank you. – Gabriel Katzberg Aug 05 '20 at 17:18
  • 1
    https://stackoverflow.com/questions/24954722/how-do-you-create-a-reverse-pivot-in-google-sheets – BigBen Aug 05 '20 at 17:19

1 Answers1

1

maybe:

=ARRAYFORMULA(QUERY(SPLIT(FLATTEN(IF(B2:D="",,A2:A&"♀"&B1:D1&"♀"&B2:D)), "♀"), 
 "where Col2 is not null", 0))

enter image description here

or maybe:

=ARRAYFORMULA(QUERY(SPLIT(FLATTEN(IF(B2:D="",,A2:A&"♀"&B1:D1&"♀"&B2:D)), "♀"), 
 "select Col1,Col2,sum(Col3) 
  where Col2 is not null 
  group by Col1,Col2 
  order by Col1,Col2,sum(Col3) 
  label sum(Col3)''", 0))

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124