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
Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2009/01/20/repeating-a-set-of-data.aspx
Posted
Jan 20 2009, 08:17 PM
by
Microsoft Excel