Converting Data from Rows to Columns

[A]

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

 

[aaron.kempf]

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.

 

[shelfish]

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!

 

[A]

Fantastic.

Thanks very much, I appreciate your help.