Martin
asked on
A very long series
I have sets of very long lists of numbers ranging from 9,000 to 13,000 numbers long. I need to create a list where the first number in the list is placed in A1 for example, and then there are 9 blank cells, then A11 would contain the second number, 9 blanks, A21 would contain the 3rd number, etc. This is the first problem.
My second problem is this. There will be a repeating series of 9 numbers, in cells A2-A10 for example that will need to be inserted into the 9 blank cells in the series above.
If I cannot get this to work, I figure my best option is to copy and paste the repeating series of 9 numbers with a blank every 10th cell (which I can do easily), and then manually type in every 10th number. Since the series containing every 10th number is at least 9000 numbers long, this will take a considerable amount of time to finish each table. Any help would be greatly appreciated.
My second problem is this. There will be a repeating series of 9 numbers, in cells A2-A10 for example that will need to be inserted into the 9 blank cells in the series above.
If I cannot get this to work, I figure my best option is to copy and paste the repeating series of 9 numbers with a blank every 10th cell (which I can do easily), and then manually type in every 10th number. Since the series containing every 10th number is at least 9000 numbers long, this will take a considerable amount of time to finish each table. Any help would be greatly appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ssaqibh,
This perfectly worked for creating the first series as described for my first problem. Your directions were very clear. I was able to complete the task by creating a series in Column B with the first cell blank, and the next 9 cells below containing the repeating series of 9 numbers. Using the fill series, I was able to extend this pattern to the sufficient length. I then used Column C, where the first cell was equaled to the same row in Column A, and the next 9 cells were equaled to their respective cells on the same row in Column B. Using fill series once again, I was able to complete this very long series in matter of seconds, and then copy and paste the text into the spreadsheet table I was creating. Thanks for the initial knowledge to see this through to completion!
This perfectly worked for creating the first series as described for my first problem. Your directions were very clear. I was able to complete the task by creating a series in Column B with the first cell blank, and the next 9 cells below containing the repeating series of 9 numbers. Using the fill series, I was able to extend this pattern to the sufficient length. I then used Column C, where the first cell was equaled to the same row in Column A, and the next 9 cells were equaled to their respective cells on the same row in Column B. Using fill series once again, I was able to complete this very long series in matter of seconds, and then copy and paste the text into the spreadsheet table I was creating. Thanks for the initial knowledge to see this through to completion!
Hello, if everything went perfectly well then why a B grade?
ASKER