Formula to summeries text and make a list automatically

Hi There,

Hope someone can help with this, I want a single text field to be generated from a list of many repetitive texts.

For example rather than it be;

Hello
Hello
Hey
Hey
Hey
Hi
Hi

It comes out as

Hello
Hey
Hi

To put this in to practice in the attached spread sheet you will see the range column from A6 onward states what range each product is in. Then a single copy of each of these ranges are repeated in C118 and C126.

So where the ranges are in C118 AND C126 I want to know is it possible for excel to find and summaries these from the A column without me having to type any specific words? Or can it know when the first of a new text filled is added to then add one to C118 and C126?

Hope that makes sense and someone can help.

Many thanks,
Richard