MS Excel query

Select the table,

Copy the area

Paste special (put a tick mark in transpose)

You get the transposed table (row↔columns)

Select each block and print.

In these cases (i have some times needed but not for this application- sometime i analyse partlist etc from net and check for similarities for material requisition = alas now SAP is about to come in and all those will be waste) - I have a good ol' foxpro - i save the file as dbf , then with small prg file i can do whatever i want, i have always found it easier to database manipulate with dbms rather than excel

You can try these in other db platforms too by exporting (less number of keyboard click than than excel)

I haven't tried it but how about defining the print area using the CTRL key?

highlight the area you want to print out - right click and copy - locate the curser on a new cell and right click and choose paste special when new drop down opens check transpose and click ok - you will have they lay out you want, so you can print by setting the print area.