It would be nice if this could be done.

[Lythande]

Hey board,

Let's say I have dates going down column A and a number going down column B. Now, I need to get this same data across instead; e.g. the dates being in row 2 and numbers in row 3 beneath. Is where any way to easily convert this from up-down to left-right?

 

[lenze]

Have a look at the TRANSPOSE function or try Copy>Paste Special>Transpose

lenze

 

[Lythande]

I love you Lenz.