Copy cell data to next row for multiple cells [Closed]

Report
Posts
2
Registration date
Tuesday February 6, 2018
Status
Member
Last seen
February 7, 2018
-
Posts
2
Registration date
Tuesday February 6, 2018
Status
Member
Last seen
February 7, 2018
-
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.

1 reply

Posts
2
Registration date
Tuesday February 6, 2018
Status
Member
Last seen
February 7, 2018

Excel experts... any suggestion?
thanks.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!