Do some Excel Work

Need to sum and transpose the data from about 1600 rows. This is a ledger that was pulled from Quickbooks. I have done several examples to guide you. The following instructions use rows 15 to 25 as an example. There are about 130 groups of data (the example set of rows 15 to 25 is one group), each group is identified by the label in column B. We will need to use the data in columns B through J to populate the summary in columns L through R. So with the data from rows 15 through 25 and columns B through J, this is how each of the result rows L through R should be completed: Column L: Is the date of the "show" which should be the common denominator per column G in the data group. Column M: is the label of the data group, which is in column B Column N: is the sum of column J when column H indicates "Musicos" for the data group Column O: is the sum of column J when column H indicates "Tecnicos" for the data group Column P: is the sum of column J when column H indicates "Renta equipos" or "Equipos" for the data group Column Q: is the sum of column J when column H indicates "Comision" for the data group Column R: is the sum of column J when column H indicates "DJ" for the data group Column S: is the sum of column J when column H indicates anything else other than the above for the data group THANKS !