The Microsoft Excel Blog has a discussion on ways of repeating a set of data, for instance making three copies of every row of a range of data. I have written a simple UDF to do this job, and also extract specified rows or columns, or rows or columns at a specified spacing.
Note that this is an array function, and must be entered with the usual array function procedure:
- Enter the function in the top left cell.
- Select the range to be covered by the function.
- Press F2
- Press Ctrl-Shift-Enter