I want from my table 1 to make table 2. I don’t know how to do it. I use libre office calc. I want every brand has his own cell and to be in same row as his imei ref unique number combination.

I tried pivot table but no result. Is there any formula how I can achieve it? Thank you for you help in advenced.