Need formula for pulling list of non-blank cells

[yako88]

Hello,
Can anyone provide a solution for the following example(A:B):
Product1, AAA
Product2, AAA
Product3, (blank)
Product4, (blank)
Product5, BBB
Product6, CCC

The formula in column C needs to find the non blank cells in column B and to return the corresponding values from column A. For the example above, column C should look like this:
Product1
Product2
Product5
Product6

Thanks in advance.

[:) Sixthsense :)]

Try Pivot Table