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