Create a pattern of text values

Calc > Make Patterned Data > Text Values

Complete the following steps to fill a column with a pattern of text values, such as High, Medium, and Low.

In Store patterned data in, enter a column number (for example, C1) or a column name. If the name contains spaces, enclose the name in single quotation marks.
In Text values (eg, red "light blue"), enter the sequence of text values, separated by spaces. If the text value contains spaces, enclose the value in double quotation marks.
Enter the repeat information for the pattern.
1. In Number of times to list each value, enter the number of consecutive times to list each value in the sequence.
2. In Number of times to list the sequence, enter the number of times to repeat the entire sequence.

For example, these settings create the following column of data.