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??