Repeating a set of data

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

For example:











This entry was posted in Arrays, Excel, UDFs, VBA. Bookmark the permalink.

1 Response to Repeating a set of data

  1. Pingback: Daily Download 33: Miscellaneous | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.