Hello, I hope I can get some help here. I don't use excel often, but there's one project a year we have to use it for. How we've been doing this in the past has been very labor extensive. I know there has got to be a way to do this simply.......here it is....

I have approx 9000 rows on a spread sheet (alphabetical by last name) and each row contains 7 columns of data. That data we need to print into a book form each year so we like to get that data into two columns (each of 7 columns of its own) on one page and keep it alphabetical at the same time. We can copy and paste, copy and past....but I know there has to be a way to do this nearly instantly.

Thanks for any help.