Eirman
asked on
Merge Multiple Blank Ranges
Starting with a blank sheet, I want to merge groups of 7 cells as follows ....
A1:A7
A7:A14
A15:A21
A22:A28
Etc. down to approximately row 1500
Doing it manually is a pain.
Is there any way of automating it?
A1:A7
A7:A14
A15:A21
A22:A28
Etc. down to approximately row 1500
Doing it manually is a pain.
Is there any way of automating it?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the alternative suggestions Saurabh Singh Teotia & helpfinder