I have a table with the following format:

CCT Part V1 V2 V3
C47 32000-029 NF
C57 32000-027 NF
C98 32000-004 NF NF
C102 32000-004 NF NF
C118 32000-029 NF NF
C119 32000-029 NF NF
C120 32000-029 NF NF
C121 32000-070 NF NF NF

The number of columns and rows can vary but there will always be a
minimum
of 3 columns
I need to reformat the table to limit the number of rows to say 40 and
move
the data below this row to new columns, ie

CCT Part V1 V2 V3 CCT Part V1 V2 V3 CCT Part V1 V2 V3

is there anyway of doing this in a macro?

I need to do this so that I can output a landscape format BMP file.

Thanks
Pete