How to populate cells from above from another column (array)

[Phenomi]

Hi

I have list of values churned out in an array which i cannot format on. Given that, I would like to copy the array into another column in which i believe it will be easier to manipulate the data. However, how do you copy the above values for blank cells in the mirrored column? I have tried using "go to special" and using "blank cells" but as the mirrored blank cells contain "=" formula, excel does not see it as a blank.

Will be great if anyone can help!

Thanks
Rayson

[benishiryo]

hey Rayson. one way is to filter blanks. and do the similar method you know of.
1. select the blanks.
2. type:
=
3. type the cell reference above since you can't use up arrow key in this instance where it's filtered. so A2 for your eg.
4. Press CTRL + ENTER