i need help to copy the row of contents to the end

Hi All

In the worksheet SKU1(1)
I need to copy the contents in column A row 1 down to column A row 13 which are the same
I need to copy the contents in column A row 14 down to column A row 21 which are the same
I need to copy the contents in column A row 22 down to column A row 29 which are the same
I need to copy the contents in column A row 30 down to column A row 42 which are the same
& so forth right to the end of the row

I cannot copy the whole row because some have numbers and it copies in sequence like if there is no 5 it copies 6 to the next row 7,8,9
I Hope you get the picture
Thanks a Million
Karl

I need to copy the contents in column A row 1 down to column A row 13 which are the same
A1:Portable Bluetooth Stereo Speaker For iPhone Smartphone Device
A2:Portable Bluetooth Stereo Speaker For iPhone Smartphone Device
A3:Portable Bluetooth Stereo Speaker For iPhone Smartphone Device

A11:Portable Bluetooth Stereo Speaker For iPhone Smartphone Device
A12:Portable Bluetooth Stereo Speaker For iPhone Smartphone Device
A13:Portable Bluetooth Stereo Speaker For iPhone Smartphone Device

I need to copy the contents in column A row 14 down to column A row 21 which are the same
A14:Portable Bluetooth Stereo Speaker For iPhone Smartphone Device
A15:Portable Bluetooth Stereo Speaker For iPhone Smartphone Device
A16:Portable Bluetooth Stereo Speaker For iPhone Smartphone Device

A20:Portable Bluetooth Stereo Speaker For iPhone Smartphone Device
A21:Portable Bluetooth Stereo Speaker For iPhone Smartphone Device

I need to copy the contents in column A row 22 down to column A row 29 which are the same
A29:Portable Bluetooth Stereo Speaker For iPhone Smartphone Device

I need to copy the contents in column A row 30 down to column A row 42 which are the same
A:30Foldable Bluetooth Headset Headphone For iPhone Smartphone Device

I need it copied like the above (without the space)

try this tell me,

Please Login or Register  to view this content.

Glad I could help PLEAE ADD MY REPUTATION BY CLICKING STAR BUTTON AT THE BOTTOM OF MY POST.

PLEASE SEE THE ATTACHMENT AND FIND YELLOW HIGHLIGHTED TO MARK THIS THREAD AS SOLVED.