fill cell with above data

[bkcffee]

hello all

my A column data
ABC
Blank
Blank
A12
Blank
789
Blank
Blank
Blank

I want to fill the blank cell with data above it if possible

thanks in advance

[sandy666]

try with PowerQuery

Power Query for

• Excel 2010 Pro Plus or Excel 2013 Pro Plus can be downloaded as free add-in from MS site (choose correct version). I suggest Power Pivot also
• Excel 2016 or Excel 365 is built-in, aka Get&Transform
• PowerQuery works with M-language and does not contain any classic formulae or vba code
• What PowerQuery is? see here: Getting Started with PowerQuery (Get&Transform) in Excel

[jtakw]

Hi,

You can also do this:

Select the Entire data range in Column A (i.e. A1:A9), hit F5, click "Special...", on left side of dialogue box, choose "Blanks", click "OK". IN the Formula Bar, enter:

=A1

Hold down CTRL, hit Enter.