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:
[TABLE="class: grid, width: 75"]
<tbody>[TR]
[TD]Col A[/TD]
[/TR]
[TR]
[TD]Albania[/TD]
[/TR]
[TR]
[TD]#Value![/TD]
[/TR]
[TR]
[TD]Australia[/TD]
[/TR]
[TR]
[TD]#Value![/TD]
[/TR]
</tbody>[/TABLE]


I want to consolidate this list in Col.A into another column B, but without any errors "#Value!"; like this
[TABLE="class: grid, width: 75"]
<tbody>[TR]
[TD]Col B[/TD]
[/TR]
[TR]
[TD]Albania[/TD]
[/TR]
[TR]
[TD]Australia[/TD]
[/TR]
</tbody>[/TABLE]

How do I go about this?

Thanks!

 

[oldbrewer]

a pivot table with #value unchecked