Automation of columns

[Wiggy74]

Good afternoon all

I have been given a spreadsheet which has 1 column called "Text" which has 4,950 rows.

Each row has a text string, but I need to put these into 88 columns so I can n'up it correctly when printing.

Other than literally cutting and pasting is there a quicker way to do this?

Thanks in advance.

Wiggy

[Pete_UK]

It would help if you attached a sample workbook - see the yellow banner at the top of the page for details on how to do this.

Pete

[Wiggy74]

File sample now attached. I basically need 1 text in every column 1 - 88 and then record 89 becomes the first record of row 2 and so on.

[Wiggy74]

I am not sure whether it would be an easier fix it I copy and transpose so I have 4,950 columns and then at every 88th column, drop down to the next row?

[Pete_UK]

Create a new Sheet2, and put this formula in cell A1:

=INDEX(Sheet1!$A:$A,(ROWS($1:1)-1)*88+MOD(COLUMNS($A:A)-1,88)+1)

and then copy across to cell CJ1 (88th column).

Format those cells to wrap text and adjust the column width as required, then copy down as far as you need to.

Hope this helps.

Pete