I have Column A (two empty rows between data), and I need to get to column B with a formula
<tbody>
Column A
Column B
a
a
a
b
b
b
c
c
c
</tbody>
I am an excel novice trying to keep up! Any explination along with a solution would be greatly appreciated :)