Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there some sort of mechanism in Excel that lets you create data using a specific pattern? Something like a regex that does all the possibilities.

For example:


Would generate


and so forth.

share|improve this question
@Excellll's answer will work fine, but will change values if the rows are re-sorted, added or otherwise modified. If you want something more flexible and where values become "locked", let us know and we can work on something a little more complex. – dav Aug 6 '12 at 19:34
up vote 2 down vote accepted

As far as I know, there's nothing built in specifically for this purpose. You can, however, get clever and use a formula to generate all the possibilities. In A1, enter the following and fill down (to A64):

share|improve this answer
note that if you need it to start in a different place, the easiest way is to put this formula in a separate spreadsheet, then copy the values instead of the formulas – SeanC Aug 6 '12 at 21:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .