Ok, I could use some excel help. I have a sheet with a list of 1000 addresses. On a second sheet I need to copy each address 9x and then move on to the next address on the first sheet. How do I do that?
eg:
123 Oak Street
345 Maple Blvd
965 Main Ave
Output:
123 Oak Street
123 Oak Street
123 Oak Street
123 Oak Street
123 Oak Street
123 Oak Street
123 Oak Street
123 Oak Street
123 Oak Street
345 Maple Blvd
345 Maple Blvd
345 Maple Blvd
345 Maple Blvd
345 Maple Blvd
345 Maple Blvd
345 Maple Blvd
345 Maple Blvd
345 Maple Blvd
etc