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 600 and repeat each value, 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, if you can suffer through a...