Filling empty cell with value from the cell above
 

After a copy-paste from a pivot table
i have a lot of empty cells
that i want to fill with the values from the cell above
to generate a new database

something like this:
Col A Col B Col C
X 1 1
2
2 1
Y 3 2
3

turned into this:
Col A Col B Col C
X 1 1
X 1 2
X 2 1
Y 3 2
Y 3 3


maybe a macro??

Filling empty cell with value from the cell above
 

No macro needed. Select the whole range of cells making up your table. Press
F5, then click Special Blanks OK. Now all the blank cells within your
table are selected. Press the equal sign (=), then the up arrow. Hold down
the Ctrl key and press Enter. This puts a formula in every blank cell,
pulling the value from the cell above it. Finally, copy & paste the whole
table in place as values.

Hope this helps,

Hutch

"Alonso" wrote:

After a copy-paste from a pivot table
i have a lot of empty cells
that i want to fill with the values from the cell above
to generate a new database

something like this:
Col A Col B Col C
X 1 1
2
2 1
Y 3 2
3

turned into this:
Col A Col B Col C
X 1 1
X 1 2
X 2 1
Y 3 2
Y 3 3


maybe a macro??

Filling empty cell with value from the cell above
 

it worked!!
great!!

thanks

"Tom Hutchins" wrote:

No macro needed. Select the whole range of cells making up your table. Press
F5, then click Special Blanks OK. Now all the blank cells within your
table are selected. Press the equal sign (=), then the up arrow. Hold down
the Ctrl key and press Enter. This puts a formula in every blank cell,
pulling the value from the cell above it. Finally, copy & paste the whole
table in place as values.

Hope this helps,

Hutch

"Alonso" wrote:

After a copy-paste from a pivot table
i have a lot of empty cells
that i want to fill with the values from the cell above
to generate a new database

something like this:
Col A Col B Col C
X 1 1
2
2 1
Y 3 2
3

turned into this:
Col A Col B Col C
X 1 1
X 1 2
X 2 1
Y 3 2
Y 3 3


maybe a macro??