How to merge all table records into one?

Question

MySQL

I have a table like:

I want to combine them in such a way that at the end it turns out like this:

Please help, dear programmers.

Answer 1

how much data is in the db? the whole problem is that how to determine that core i5 belongs to the samsung brand