Example of generating patterned text data

A customer service manager wants to record the number of support calls per hour for a week for three different representatives: Lucia, Greg F, and Greg M. The manager creates a column of text data that repeats the three names.

  1. Open the Generate Patterned Text Data dialog box.
    • Mac: Data > Generate Patterned Data > Text
    • PC: DATA > Patterned Data > Text
  2. In Text values, enter Lucia "Greg F" "Greg M".
  3. In Number of times to list the whole sequence, enter 40.
  4. Click OK.
  5. Click the column name cell and enter Representative.

Results

The patterned data are in a column of the worksheet. The customer service manager can record the number of support calls in the corresponding row of a new column.

C1
Representative
Lucia
Greg F
Greg M
Lucia
Greg F
Greg M
Lucia
Greg F
Greg M
...
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy