Use Make Patterned Data to generate repeating sequences of numbers, text values, or date/time values. You can repeat a sequence of equally-spaced numbers or date/time values, unequally-spaced numbers or date/time values, or text values.
For example, a quality engineer wants to measure parts from three machines, at two temperatures, during every work shift for a week. The engineer generates columns of patterned data for the machine ID, temperature setting, and work shift.
If you want to generate random data, use .
You can create repeating sequences of values in a column with Autofill. Autofill is the quickest method of creating patterned data. For more information, go to Enter data quickly by using Autofill.