Copy cell data to next row for multiple cells

Closed
bmr12 Posts 2 Registration date Tuesday February 6, 2018 Status Member Last seen February 7, 2018 - Updated on Feb 6, 2018 at 06:03 PM
bmr12 Posts 2 Registration date Tuesday February 6, 2018 Status Member Last seen February 7, 2018 - Feb 7, 2018 at 09:41 PM
Hello,
Need help copying cell data to next row for multiple cells.
e.g.

Source data -
A1 Cat
A2 (blank cell)
A3 Dog
A4 (blank cell)
A5 Hen
A6 (blank cell)

Target data -
A1 Cat
A2 Cat
A3 Dog
A4 Dog
A5 Hen
A6 Hen

thanks.
Related:

1 response

bmr12 Posts 2 Registration date Tuesday February 6, 2018 Status Member Last seen February 7, 2018
Feb 7, 2018 at 09:41 PM
Excel experts... any suggestion?
thanks.
0