Copy cell data to next row for multiple cells

Closed

bmr12 Posts 2 Registration date Tuesday 6 February 2018 Status Member Last seen 7 February 2018 - Updated on Feb 6, 2018 at 06:03 PM
bmr12 Posts 2 Registration date Tuesday 6 February 2018 Status Member Last seen 7 February 2018 - 7 Feb 2018 à 21:41

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.

Copy cell data to next row for multiple cells
How to copy data from one excel sheet to another - Guide
Excel multiple lines in one cell - Guide
Saints row 2 cheats - Guide
How to copy data to multiple worksheets in Excel - Guide
How to download multiple files from whatsapp web - WhatsApp Forum

1 response

Réponse 1 / 1

bmr12 Posts 2 Registration date Tuesday 6 February 2018 Status Member Last seen 7 February 2018
7 Feb 2018 à 21:41

Excel experts... any suggestion?
thanks.

Similar discussions

Consolidate data from multiple sheets to one sheet.

Clear cell contents based on value of another cell range using VBA

Copying data from one Excel sheet to another.

help me to add particular cells

Hosted app data will not clear

Similar discussions

Subscribe To Our Newsletter!