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.

  1. 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.
  2. 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.
  3. 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.

  • Text values (eg, red "light blue"): purple green "dark red"
  • Number of times to list each value: 2
  • Number of times to list the sequence: 3
C1-T
Colors
purple
purple
green
green
dark red
dark red
purple
purple
green
green
dark red
dark red
purple
purple
green
green
dark red
dark red
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy