Hello!

I have a list where the first cell applies to all the cells below it that looks similar to this:

Grocery
Apples
Bananas
Kiwi

Pharmacy
Medicine
Tissues

I'm trying to copy and paste the first cells of the groups (Grocery and Pharmacy) to be in the same row as the others. Is there any function/macro that I can do to do this automatically?