This requires a simple macro. Do you want a space inbetween each group. How
do you want to assign a number? Write the number in column A? Need a little
more details to get it right.

"SerpentineFire" wrote:

I need divide a list of 500 lines into groups of 8 and assign a number or
name to each group