Copying a row to a column

[CharlieBeth]

I have a table with a list of names going across the top, I need to dulpicate these names in another table, in the same order, but as a column.

Is there a quick way of doing this?

 

[adam087]

[Edit (XL2003)]/[Home Tab (XL2007/10)] -> Paste Special -> Transpose

 

[CharlieBeth]

It worked fine on my names. I also need to do the same in the next coloumn but with a sum of money (wages to be paid). When I try to do the same with the numbers I get #ref

I was hoping for something like (forgive my noob language) =a1 which I can then drag over the whole area as names will sometimes change, and amounts will change daily.

 

[adam087]

You could play with offset
=OFFSET('Other Sheet'!$A$1, column()-1, row()-1)

Might need some tweaking though

 

[Weaver]

I'm guessing the amounts have formulas.

Try selecting the 'values' option when using 'transpose'

 

[CharlieBeth]

You could play with offset
=OFFSET('Other Sheet'!$A$1, column()-1, row()-1)

Might need some tweaking though

Got that working, did take some playing around and I'm not sure I understand it... but it works!

 

[CharlieBeth]

I'm guessing the amounts have formulas.

Try selecting the 'values' option when using 'transpose'

Tried... didn't work. Thanks though

 

[Weaver]

Tried... didn't work. Thanks though

When you say "didn't work", is that because you wanted live results (i.e formulas) rather than fixed values?