Let me rewrite this with better wording. Thanks arthurbr for your attempt, it sort of worked. I have a column of names that has 588 names in it. A1 is the heading. A2 starts the first name (joe in this example) A3 is Deb A4 is tom, and so on until i hit cell 589 which has the last name. I need to make these 588 names into 5880 cells with each name being repeated 10 times in a row.
A1 heading A2:A13 joe,deb,tom,mary,paul,don,kati,liz,buck,jason,lisa,brian
I need it like this...A1 heading A2:A13 joe,joe,joe,joe,joe,joe,joe,joe,joe,joe,deb,deb,deb,...and so on until the name in cell A589 in in cells A5872:A5881
thanks for any help you can give
Bookmarks