Modifying data to a specific format

Hi Excel Experts,

I need to convert the data from the file "The Source" to the format of "The Result". See example: PART 1 from "The Source" with all its models should be listed in line 2 from "The Result". All models from same make for PART 1 should be shown in 1 (same) cell (if possible, separated by comma) - please see I2 from "The Result". In front of these models (H2) should be listed the type of the machine - skid steer loader, wheel loader, etc. Please note that I have 2 sheets with data - "Summary 1" and "Summary 2" and also I have not listed all the makes as titles in "The Result" - could you show the full list, based on the makes in the source file?

Thank you.

On question for clarification: Do you want to get the result based on Summary 1 or Summary 2?

I would like to have both - summary 1 and summary 2 - if possible on separate sheets, if not - on same. Thank you.

I'm closing the thread. I managed to get the requested formatting in one cell using =CONCATENATE(TRANSPOSE(C1:C5 & ", ")) formula.