I have this on A1

GEMMA 30 X 60 = EDEN BEIGE
GEMMA 30 X 60 = EDEN DARK MAUVE
GEMMA 30 X 60 = EDEN NOCCE
GEMMA 25 X 75 = GLORY BEIGE
GEMMA 25 X 75 = GLORY PLATINE KIT 1 GREY DECOR
GEMMA 25 X 75 = GLORY BROWN
GEMMA 25 X 75 = GLORY GEO GOLD BROWN DECOR
GEMMA 30 X 60 = LUGANO BEIGE
GEMMA 30 X 60 = LUGANO GREY
GEMMA 30 X 60 = LUGANO GEO BEIGE

I want on B1 formula which I drag down to give result

EDEN
GLORY
LUGANO