|I have thousands of rows of data, so a loop macro is definitely needed.|
Well, not definitely...
It can be done with a formula.
Assuming your data is in Sheet1, put this in A1 of any other sheet:
Change Sheet1!$A$1:$E$4 to refer to the actual range of your "thousands of rows".
Change the 5's to match the number of columns in your table.
In other words, your example uses column A:E, so I used 5. If your data is in A:G, use 7's instead of 5's. Leave the ".1", just change the 5's. All three of them.
Drag the formula down as far as you need.