I have big like following

Cables and Cords
R9858 Round Gray Cable
HH942 Optical Drive Serial ATA
NJ889 Thermal Sensor Cable
MK154 Cable Assembly for

Ribbon
X9259 Ribbon Cable for DIAG
FH439 Cable Assembly for Flex-Bay
5120P Power Cord, 6FT,
5R598 Power Cord, 6FT,
MK524 Hard Drive Serial



there is a big file with different headings


I need to delete the heading(cables and cords, Ribbon many more) and
put in the same row next to each record like following

R9858 Round Gray Cable Cables and Cords
HH942 Optical Drive Serial ATA Cables and Cords
NJ889 Thermal Sensor Cable Cables and Cords
MK154 Cable Assembly for Cables and Cords
X9259 Ribbon Cable for DIAG Ribbon
FH439 Cable Assembly for Flex-Bay Ribbon
5120P Power Cord, 6FT, Ribbon
5R598 Power Cord, 6FT, Ribbon
MK524 Hard Drive Serial Ribbon

Any macro for it?

thanks in advance