T Nation

Help with Excel List?

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

excel

Try copying the row/all of it, paste x9, sort the results alphabetically

3 Likes

ohhhhhhhhhhh, that’s pretty good.

You only have to enter each value once, then drag to copy in the below cells. Once you do a column, copy the column and paste it where you want it. Repeat as necessary