In the Generate Patterned Numeric Data dialog box, specify the type of pattern, the base sequence, and the repetition pattern.

Select the type of pattern to create and then enter the base sequence.

Select this option to generate a column of evenly spaced numbers, such as 1, 2, 3, 1, 2, 3, or 3, 3, 2, 2, 1, 1. Then complete the following steps to enter the base sequence.

- In First number, enter the starting value for the sequence.
- In Last number, enter the smallest or largest possible value for the sequence.
- In Size of each step, enter the increment or decrement for each step in the sequence. This value must be greater than zero.

First number | Last number | Size of each step | Base sequence |
---|---|---|---|

1 | 8 | 2 | 1 3 5 7 |

7 | 1 | 2 | 7 5 3 1 |

30 | 50 | 5 | 30 35 40 45 50 |

Select this option to generate a column of numbers that are not equally spaced, such as 10, 20, 50. Then, in Numbers in the base sequence, enter the numbers to include in the pattern.

- In Number of times to list each value, enter the number of times that you want each value in the sequence to be consecutively repeated.
- In Number of times to list the whole sequence, enter the number of times that you want to repeat the entire sequence.

Base sequence | Number of times to list each value | Number of times to list the whole sequence | Output |
---|---|---|---|

10 20 | 3 | 1 | 10 10 10 20 20 20 |

1 7 6 | 1 | 3 | 1 7 6 1 7 6 1 7 6 |

A Z O | 2 | 2 | A A Z Z O O A A Z Z O O |