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.

1 reply

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