Spreadsheet: 800528d1665709613-combine-automatically-all-values-from-ranges-of-cells-into-a-new-format-range-of-cells-question-l4cky-
Sheet: Sheet2

 |  |  |  |  |  |  |  |  | Formula 1 to obtain: | Combine automatically all values from A6 to G39 into this new format range of  cells J6 to N6 where we combine each unique Class and Type into the same row, do not display empty rows. If no values, in old or new (columns M and N), write 0. If possible, to have only the class and type columns display as Text format (K&L).
Year | Class | Type | New | Class | Type | Old | Count |  |  | Year | Class | Type | Old | New |  | Year | Class | Type | Old | New
2018 | 13 | (Fx) | 15025.16 |  |  |  |  |  |  | 2018 | 13 | (Fx) | 3397.14 | 15025.16
2018 | 8 | (E) | 4185.07 |  |  |  |  |  |  | 2018 | 46 | (E) | 19.97999999999979 | 470.9200000000001
2018 | 12 | (E) | 2173.79 |  |  |  |  |  |  | 2018 | 50 | (E) | 570.0000000000005 | 1869.139999999999
2018 | 12s | (E) | 75.66 |  |  |  |  |  |  | 2018 | 8 | ([NAME]) | 3324.329999999999 | 2111.45
2018 | 46 | (E) | 470.9200000000001 |  |  |  |  |  |  | 2018 | 13 | ([NAME]) | 873.7000000000007 | 28942.45
2018 | 50 | (E) | 1869.139999999999 |  |  |  |  |  |  | 2018 | 8 | (E) | 4185.07 | 0
2018 | 8 | ([NAME]) | 2111.45 |  |  |  |  |  |  | 2018 | 12 | (E) | 2173.79 | 0
2018 | 13 | ([NAME]) | 28942.45 |  |  |  |  |  |  | 2018 | 12s | (E) | 75.66 | 0
2018 |  |  |  | 13 | (Fx) | 3397.14 |  |  |  | 2019 | 13 | (Fx) | 0 | 517.8600000000006
2018 |  |  |  | 46 | (E) | 19.97999999999979 |  |  |  | 2019 | 8 | (E) | 0 | 4365.76
2018 |  |  |  | 50 | (E) | 570.0000000000005 |  |  |  | 2019 | 12 | (E) | 0 | 1014.93
2018 |  |  |  | 8 | ([NAME]) | 3324.329999999999 |  |  |  | 2019 | 50 | (E) | 0 | 3296.120000000003
2018 |  |  |  | 13 | ([NAME]) | 873.7000000000007 |  |  |  | 2019 | 8 | ([NAME]) | 0 | 2016.51
2019 | 13 | (Fx) | 517.8600000000006 |  |  |  |  |  |  | 2020 | 8 | (E) | 267.6000000000004 | 0
2019 | 8 | (E) | 4365.76 |  |  |  |  |  |  | 2020 | 50 | (E) | 998.9199999999983 | 0
2019 | 12 | (E) | 1014.93 |  |  |  |  |  |  | 2020 | 8 | ([NAME]) | 251.8599999999988 | 0
2019 | 50 | (E) | 3296.120000000003 |  |  |  |  |  |  | 2021 | 8 | (E) | 7733.390758049316 | 0
2019 | 8 | ([NAME]) | 2016.51 |  |  |  |  |  |  | 2021 | 50 | (E) | 2766.226591698779 | 0
2019 |  |  |  |  |  |  |  |  |  | 2021 | 8 | ([NAME]) | 5880.034383351231 | 0
2019 |  |  |  |  |  |  |  |  |  | 2021 | 13 | (Fx) | 15693.38252876712 | 1997.299999999999
2020 |  |  |  | 8 | (E) | 267.6000000000004 |  |  |  | 2021 | 13 | ([NAME]) | 22274.7425 | 0
2020 |  |  |  | 50 | (E) | 998.9199999999983 |  |  |  | 2021 | 46 | (E) | 399.9772587932877 | 0
2020 |  |  |  | 8 | ([NAME]) | 251.8599999999988
2020 |  |  |  |  |  |  |  |  | [NAME] to obtain | Same as table one but only display the Year, Class (text format) and Type (text format)
2020
2020 |  |  |  |  |  |  |  |  |  | Year | Class | Type
2021 | 13 | (Fx) | 1997.299999999999 |  |  |  |  |  |  | 2018 | 13 | (Fx)
2021 |  |  |  | 8 | (E) | 7733.390758049316 |  |  |  | 2018 | 46 | (E)
2021 |  |  |  | 50 | (E) | 2766.226591698779 |  |  |  | 2018 | 50 | (E)
2021 |  |  |  | 8 | ([NAME]) | 5880.034383351231 |  |  |  | 2018 | 8 | ([NAME])
2021 |  |  |  | 13 | (Fx) | 15693.38252876712 |  |  |  | 2018 | 13 | ([NAME])
2021 |  |  |  | 13 | ([NAME]) | 22274.7425 |  |  |  | 2018 | 8 | (E)
2021 |  |  |  | 46 | (E) | 399.9772587932877 |  |  |  | 2018 | 12 | (E)
 |  |  |  |  |  |  |  |  |  | 2018 | 12s | (E)
 |  |  |  |  |  |  |  |  |  | 2019 | 13 | (Fx)
 |  |  |  |  |  |  |  |  |  | 2019 | 8 | (E)
 |  |  |  |  |  |  |  |  |  | 2019 | 12 | (E)
 |  |  |  |  |  |  |  |  |  | 2019 | 50 | (E)
 |  |  |  |  |  |  |  |  |  | 2019 | 8 | ([NAME])
 |  |  |  |  |  |  |  |  |  | 2020 | 8 | (E)
 |  |  |  |  |  |  |  |  |  | 2020 | 50 | (E)
 |  |  |  |  |  |  |  |  |  | 2020 | 8 | ([NAME])
 |  |  |  |  |  |  |  |  |  | 2021 | 8 | (E)
 |  |  |  |  |  |  |  |  |  | 2021 | 50 | (E)
 |  |  |  |  |  |  |  |  |  | 2021 | 8 | ([NAME])
 |  |  |  |  |  |  |  |  |  | 2021 | 13 | (Fx)
 |  |  |  |  |  |  |  |  |  | 2021 | 13 | ([NAME])
 |  |  |  |  |  |  |  |  |  | 2021 | 46 | (E)