Consolidating List of Cells

[suneeshkaul]

Hey! Thanks for the help, in advance.

I have a list of cells (say in Col A) in the form:

Col A

Albania

#Value!

Australia

#Value!

<tbody>
</tbody>

I want to consolidate this list in Col.A into another column B, but without any errors "#Value!"; like this

Col B

Albania

Australia

<tbody>
</tbody>

How do I go about this?

Thanks!

 

[oldbrewer]

a pivot table with #value unchecked