Insert 5 rows between existing values in a single column 1
I have a sheet with over 10,000 rows of existing data, all in a single column.
I need to insert 5 rows in between each existing row quickly and easily.
Doing it manually is not so efficient!
For example:
F14745
F14746
F14747
needs to become:
F14745
F14746
F14747
etc.,
Likey a way to do this with a Macro, but I don't have a clue on how to do it.
Easy way seems to elude me.
Thanks.
|