I have a large table of data that contains many rows of information,
categorised by row. I would like to be able to convert this into a table
with the same date categorised into columns.

E.g. Row 4 contans the data '531,331,342 etc'
I would like this data to be presented down column D in the same order.

The reason for this is that It would be far easier for me to copy formulas
down the columns rather than along the rows.

How can I do this?

Thanks in advance

keep your data in a database; and it is easy to turn it into rows or
columns.

excel is 1-dimensional. run away while you still can.

A better response would be, select all of your data and copy. I
recommend you select a new sheet (but you don't have to) and select
"Paste Special..."

In the menu select "Transpose" and see what happens. It should do what
you're asking.

Cheers!

Fantastic.

Thanks very much, I appreciate your help.


"shelfish" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>A better response would be, select all of your data and copy. I
> recommend you select a new sheet (but you don't have to) and select
> "Paste Special..."
>
> In the menu select "Transpose" and see what happens. It should do what
> you're asking.
>
> Cheers!
>