How to print list of data into two columns on a page

[ajc623]

I have a list of products that I have employees use as a reference sheet to confirm they are picking the correct item # in our shipping department. The sheet is set up as

column A - item #
column B - Item name
column C - Small picture of item
column D - how to package the item

As I need to add/remove products from time to time I have it as a single width using columns A-D but since the info is fairly simple I would like to be able to print it with those 4 columns listed twice per page. I can fit twelve rows per page with a header on top. So my goal would be to have this

Row 1 - header in A-D and then again in E-H
Range A2:D13 would be the first 12 products in my list
Range E2:H13 would be products 13-24 on my list

This would repeat with all remaining products in the list.



Thanks
Andrew

 

[ajc623]

Here is an example of what I am talking about EXAMPLE

Thanks Andrew