Windows 7 Professional Repeating a Set of Data
 

I thought this would be interesting to share to see how other Excel folks might have solved this problem. I got a question recently from a customer asking how to automatically take a set of values in one column, say:1000
5000
600and repeat each value,Office 2010 Activation, say, 4 times in the next column, so that it looks something like this:1000
1000
1000
1000
5000
5000
5000
5000
... and so on.My response: the only way to truly do this automatically is to write a custom macro. However,Windows 7 Home Premium, if you can suffer through a few extra clicks,Microsoft Office 2007, then my suggestion would be to (using the example data above): Select the three input cells (e.g. A1:A3)Select “Copy” (Ctrl+C)Select the next 9 cells underneath these inputs (A4:A12)Select “Paste” (Ctrl+V)Click the Sort button to sort the data into 3 distinct buckets (600,Windows 7 Ultimate Key, 1000,Windows 7 Professional, 5000).For step #3, the number of cells you select will always be: NumberOfInputs x NumberOfRepetitions – NumberofInputs. In this case: 3 x 4 – 3 = 9.That seemed to work well enough for the customer. What do you think? Is there another (better?) way? <div